Day 3 - DynamoDB (Analytics Perspective): Key Design and Stream-Based Pipelines

Amazon DynamoDB is a fully managed serverless NoSQL key-value/document database providing single-digit millisecond latency and near-unlimited scale. While fundamentally OLTP, data engineers must understand key design and stream-to-analytics pipelines.

DynamoDB Fundamental Model

Data is organized as table → items (rows) → attributes (columns). Each item identified by primary key.

• Partition Key (PK): Hashed to determine physical partition where data is stored.
• Sort Key (SK): Orders items within same partition. PK+SK combination is composite primary key.