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 does the DynamoDB query return?
- How to divert the traffic from S3 to DynamoDB?
- How to access DynamoDB from Apache Hive?
- How to tell if DynamoDB initialized correctly?
- How to dump multiple DynamoDB tables?
- How to store graphs in DynamoDB?
- Will I be charged for DynamoDB is it is inactive?
- How to access DynamoDB from Android Studio?
- How to grab data from AWS DynamoDB?
- What are the key differences between DynamoDB and Elasticsearch?
- How many DynamoDB tables can I have at a maximum?
- Is DynamoDB a managed service?
- Why is AWS DynamoDB charging me?
- How does DynamoDB handle data changes?
- Why is DynamoDB easy to partition?
Spend less time in the AWS console, use Dynobase.
Try 7-day free trial. No strings attached.
Product Features
DynamoDB Tools
DynamoDB Info
© 2025 Dynobase