DynamoDB Single Table Example

The code in this repository uses the Northwind dataset to demonstrate simple relational modeling in a single DynamoDB table. For a full walkthrough of the underlying rationale, see the accompanying blog post.

Using the code

Run python load.py --setup with valid AWS credentials in your environment to perform the following actions:

• Create a new DynamoDB table called northwind in us-east-2
• Create one GSI on the table
• Load the files in the csv folder into the table according to the data access patterns defined in the blog post that accompanies this project

The table has on-demand capacity enabled, so you shouldn't have to worry about the writes being throttled (or about being charged for capcity when you're not using the table)

If you need to reload the data, run python load.py.

Clean up with python load.py --teardown.

You can find sample boto3 queries against the data defined in query.py.