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)
- How to import data from S3 to DynamoDB?
 - Can Power BI connect to DynamoDB?
 - How to store graphs in DynamoDB?
 - Can Django use DynamoDB?
 - How do I create an id in DynamoDB?
 - Can we store list in DynamoDB?
 - What are the key differences between DynamoDB and Neo4j?
 - Is DynamoDB HIPAA compliant?
 - What does the DynamoDB query return?
 - Can you store XML in DynamoDB?
 - Should you make a new DynamoDB client for each request?
 - Can we rename DynamoDB table?
 - How do you store JSON on DynamoDB?
 - How to write a test case for mocking DynamoDB?
 - Is DynamoDB based on MongoDB?
 
Tired of AWS Console? Try Dynobase.
Try 7-day free trial. No credit card needed.
Product Features
DynamoDB Tools
DynamoDB Info
© 2025 Dynobase