- A Cloud Guru
Managing Data Relationships in DynamoDB
In this lab, we will create a data model in DynamoDB to manage one-to-one, one-to-many, many-to-many, and hierarchical data relationships.
Table of Contents
Analyze Provided Data
target_abridged.csvto plan your data model to satisfy the provided access patterns by choosing partition and sort keys for your DynamoDB table, any data transformations, and any secondary indexes that are needed.
Create a DynamoDB Table
With the information from the previous task, create a DynamoDB table in the provided AWS account.
Log in to Provided EC2 Instance
Log in to the provided EC2 instance with the credentials found in the lab interface:
load.pyto execute any data transformations from the first task.
<TABLE_NAME>with the name of your table:
python3 load.py -t <TABLE_NAME>
queries.py, updating the
queriesdictionary with the appropriate queries to satisfy each access pattern. Be sure to use the correct table and index names.
Confirm Queries Return Expected Data
Verify output against the expected output in the lab information.
What's a lab?
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.