Question: Is it possible to make a DynamoDB table case insensitive?

Answered by Rafal Wilinski
Answer
Case matters in DynamoDB. If your data is case-insensitive, convert it to lowercase or uppercase before storing it in DynamoDB. Then you can circumvent this by performing a query for all lowercase or all uppercase characters.
Making a secondary index with all the keys changed to lowercase is a potential workaround. Then, you can query that secondary index.
Other Common DynamoDB FAQ (with Answers)
- What are the naming conventions in DynamoDB?
- Is DynamoDB certification worth it?
- Can QuickSight read DynamoDB?
- Is DynamoDB stateless?
- Can Power BI connect to DynamoDB?
- Can we store list in DynamoDB?
- Can DynamoDB store documents?
- Are DynamoDB table names supposed to be unique?
- What is DynamoDB white paper, and what are the key takeaways?
- Can we pass objects as an item in DynamoDB?
- Is DynamoDB PaaS or SaaS?
- When to use DynamoDB?
- Is DynamoDB highly available?
- How to connect to DynamoDB?
- Does DynamoDB support cross-region replication?
Login to the AWS Console less. Use Dynobase.
Try 7-day free trial. No strings attached.
Product Features
DynamoDB Tools
DynamoDB Info
© 2025 Dynobase