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 store location coordinates in DynamoDB?
- Can DynamoDB store relational data?
- What is DynamoDB used for?
- How is data stored in DynamoDB?
- When to use DynamoDB?
- How to create an index in DynamoDB? (how to create an index in dynamodb)
- How do you store JSON on DynamoDB?
- Is DynamoDB cost effective?
- Is DynamoDB OLTP or OLAP?
- Is LSI automatically created on DynamoDB?
- How to access DynamoDB from EC2?
- Is DynamoDB a key-value store?
- What type of database is DynamoDB?
- Are DynamoDB tables globally unique?
- Can DynamoDB have null values?
Tired of AWS Console? Try Dynobase.
Start your 7-day free trial today
Product Features
DynamoDB Tools
DynamoDB Info
© 2024 Dynobase