Question: Can DynamoDB store relational data?

Answered by Rafal Wilinski
Answer
No, DynamoDB is not designed to store relational data. It is a NoSQL database that uses a document-based data model and is optimized for high performance and scalability. DynamoDB does not support the use of foreign keys or relationships between tables, and does not provide the ability to perform SQL-like joins on data. Instead, it is designed to be flexible and allow users to store and retrieve data in a way that is natural to the application.
That being said, you can use Single-Table Design (view examples) where all the entities are stored in one a table in a smart way.
Other Common DynamoDB FAQ (with Answers)
- Is DynamoDB real-time?
- Does sharding affect DynamoDB reads?
- How do I create an id in DynamoDB?
- Does DynamoDB have triggers?
- Why is Single-Table-Design popular in DynamoDB?
- Can I add another region to global DynamoDB?
- How to divert the traffic from S3 to DynamoDB?
- Can Power BI connect to DynamoDB?
- How to import data from S3 to DynamoDB?
- How is data stored in DynamoDB?
- Why must table be empty to enable DynamoDB global tables?
- How to access DynamoDB from EC2?
- Is DynamoDB cost effective?
- Is DynamoDB stateless?
- How resilient is DynamoDB?
Better DynamoDB experience.
First 7 days are on us. No strings attached.
Product Features
DynamoDB Tools
DynamoDB Info
© 2025 Dynobase