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)
- Can firehose write to DynamoDB?
- Will I be charged for DynamoDB is it is inactive?
- How to access DynamoDB from EC2?
- How to forcefully delete a DynamoDB table?
- How to store location coordinates in DynamoDB?
- What is the access pattern in DynamoDB?
- Does DynamoDB charge for storage?
- Can we rename DynamoDB table?
- Is DynamoDB a memory store?
- Are DynamoDB table names supposed to be unique?
- How is data stored in DynamoDB?
- How to import data from S3 to DynamoDB?
- How to count rows in DynamoDB?
- Can we pass objects as an item in DynamoDB?
- What are the differences between DynamoDB and MySQL?
Dynobase is a Professional GUI Client for DynamoDB
Start your 7-day free trial today
Product Features
DynamoDB Tools
DynamoDB Info
© 2026 Dynobase