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.
Successfully complete this lab by achieving the following learning objectives:
- 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:
- Update `load.py`
load.pyto execute any data transformations from the first task.
- Run `load.py`
<TABLE_NAME>with the name of your table:
python3 load.py -t <TABLE_NAME>
- Update `queries.py`
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.