How to AWS DynamoDB: Schema Design

In this video I show you how to design the schema for your DynamoDB. I recorded this after a coaching session where we looked into this topic. I found this such a good topic that I hat to create a video for you. In the example we use a simple airline review schema. We are also going to compare this schema to a normal relational schema.

►Learn Data Engineering with my Data Engineering Academy:

►LEARN MORE ABOUT DATA ENGINEERING:
-Check out my free 100+ page data engineering cookbook on GitHub:

►PLEASE SUPPORT WHAT YOU LIKE:
Just use this link whenever you buy something from Amazon:

(As an Amazon Associate I earn from qualifying purchases from Amazon)
This is free of charge for you but super helpful for supporting this channel.

#dynamodb #nosql #aws

[andreaskayy]

Should I do these videos where I talk about coaching topics more often?

[professional]

Wouldn't it be a better idea to keep Flight _ID as PK and cust_id as sort or sec key. Most of the times as an airline company, I am intrested in finding which flight has the worst review rather than finding which customer gave us the most good review or bad review. An average person will travel and review what 2 0times, compared that to say around 30 - 50 reviews per flight.

[muhammadmusharaf]

Thank Andreas, It cleared up my lot of confusion related to Dynamodb. 🙌🙌

[blunderfoxbeta]

Don't blindly jump on dynamodb. It has more disadvantages when it comes to listing filtering aggregation pagination.

[aliseyyidoglu]

Thank you for the great explanation Andreas

[vivekgowda]

Nice video, can we modify the table after creating on aws?

[blunderfoxbeta]

Can you answer a simple question here how to list all customers with multiple filers and my table size is 1TB?

[antonkot]

Thank you for useful content. Like the way you use Miro =)

[artiomoganesyan]

1:49 you cannot create a review table if its foreign key is in a table that is not yet created