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 best alternatives to DynamoDB?
- Is DynamoDB SQL or NoSQL?
- Is DynamoDB document-based?
- Is DynamoDB similar to MongoDB?
- How to enable DynamoDB monitoring?
- How to create an index in DynamoDB? (how to create an index in dynamodb)
- Can DynamoDB store relational data?
- Does DynamoDB Support SQL?
- Can colons and special characters be used in DynamoDB attributes?
- Are DynamoDB table names supposed to be unique?
- Can you store XML in DynamoDB?
- Is DynamoDB highly available?
- Is DynamoDB good for analytics?
- What is DynamoDB used for?
- Can DynamoDB be used like a relational database?
Dynobase is a Professional GUI Client for DynamoDB
Try 7-day free trial. No strings attached.
Product Features
DynamoDB Tools
DynamoDB Info
© 2025 Dynobase