

When the table is using On-Demand capacity, read operations will consume Read Request Units (RRUs) and write operations will consume Write Request Units (WRUs). Operations in DynamoDB consume capacity from the table. Items with the same Partition Key are said to belong to the same Item Collection.įor more information please read about Core Concepts in DynamoDB. In other words, you can have multiple items that have the same Partition Key as long as their Sort Keys are different. If your table has both a Partition Key and Sort Key, then it is possible to have multiple items that have the same Partition Key, but the combination of the Partition Key and Sort Key will be the Primary Key and uniquely identify the row.

If your table is a Partition Key only table, then the Partition Key is the Primary Key and must uniquely identify each item. At a minimum when you create a table you must choose an attribute to be the Partition Key (aka the Hash Key) and you can optionally specify another attribute to be the Sort Key. Every item must have a Primary Key which will uniquely identify that row (two items may not contain the same Primary Key). Items are a collection of Attributes, which are analogous to columns. Inside of a Table you will insert Items, which are analogous to what you might think of as a row in other services. The highest level of abstraction in DynamoDB is a Table (there isn’t a concept of a “Database” that has a bunch of tables inside of it like in other NOSQL or RDBMS services). There are two versions of the console and while you can always click “Revert to the current console” we will be working with V2 of the console. In this lab we will be exploring the DynamoDB section of the AWS Management Console. Privacy | Site terms | © 2022 Amazon Web Services, Inc. Links: NoSQL Design: Reference Materials.Step 6 - Populate the logfile table and verify replication to logfile_replica Step 5 - Map the source stream to the Lambda function Step 2 - Review the AWS IAM policy for the IAM role Exercise 8: Amazon DynamoDB Streams and AWS Lambda.Step 4 - Query the Customer details and Bill details using the Index Step 3 - Query the table's invoice details Step 2 - Review the InvoiceAndBills table on the DynamoDB console Step 1 - Create and load the the InvoiceandBilling table Step 4 - Querying all the employees of a city and a specific department Step 3 - Query all the employees of a city Step 2 - Query all the employees from a state Step 1 - Create a new global secondary index for City-Department Step 3 - Scan the employees table to find managers by using the sparse global secondary index

Step 2 - Scan the employees table to find managers without using the sparse global secondary index Step 1 - Add a new global secondary index to the employees table Exercise 5: Sparse Global Secondary Indexes.Step 3 - Query the employees table using the global secondary index with overloaded attributes Step 1 - Create the employees table for global secondary index key overloading Exercise 4: Global Secondary Index Key Overloading.Exercise 3: Global Secondary Index Write Sharding.Exercise 2: Sequential and Parallel Table Scans.Step 7 - Create a new table with a low-capacity global secondary index Step 6 - After increasing the table’s capacity, load more data Step 5 - Increase the capacity of the table Step 4 - View the CloudWatch metrics on your table Step 3 - Load a larger file to compare the execution times Exercise 1: DynamoDB Capacity Units and Partitioning.Step 6 - Preload the items for the table Scan exercise Step 5 - Check the files format and content Step 4 - Check the content of the workshop folder Step 2 - Check the Python and AWS CLI installation Step 1 - Open the AWS Systems Manager Console Workshop: Advanced Design Patterns for Amazon DynamoDB.Workshop: Modeling Game Player Data with Amazon DynamoDB.Workshop: Hands-on Labs for Amazon DynamoDB.
