Partition key selection in DynamoDB - Mini Project: Build & Apply

Partition Key Selection in DynamoDB

📖 Scenario: You are building a simple DynamoDB table to store information about books in a library. Each book has a unique ISBN number, a title, and an author.Choosing the right partition key is important to organize the data efficiently and allow fast lookups.

🎯 Goal: Create a DynamoDB table with a partition key that uniquely identifies each book by its ISBN number.

📋 What You'll Learn

Create a DynamoDB table named Books.

Use ISBN as the partition key.

Include attributes Title and Author for each book.

💡 Why This Matters

🌍 Real World

Choosing the right partition key in DynamoDB helps organize data for fast and efficient access, which is critical in real-world applications like online libraries, e-commerce catalogs, and user profiles.

💼 Career

Understanding partition key selection is essential for database administrators and backend developers working with NoSQL databases like DynamoDB to design scalable and performant data models.

1

Create the DynamoDB table with partition key

Write the AWS CLI command to create a DynamoDB table named Books with a partition key called ISBN of type S (string).

DynamoDB

# Your AWS CLI command here to create the table with partition key ISBN

Need a hint?

Use aws dynamodb create-table with --attribute-definitions and --key-schema to define the partition key.

2

Add attributes for Title and Author

Add attribute definitions for Title and Author as strings (S) in the AWS CLI command to create the Books table.

DynamoDB

aws dynamodb create-table --table-name Books --attribute-definitions AttributeName=ISBN,AttributeType=S, AttributeName=Title,AttributeType=S, AttributeName=Author,AttributeType=S --key-schema AttributeName=ISBN,KeyType=HASH --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5
# Your code here to add Title and Author attributes

Need a hint?

Include AttributeName=Title,AttributeType=S and AttributeName=Author,AttributeType=S in the --attribute-definitions section.

3

Insert a book item into the Books table

Write the AWS CLI command to put an item into the Books table with ISBN as "978-0132350884", Title as "Clean Code", and Author as "Robert C. Martin".

DynamoDB

aws dynamodb put-item --table-name Books --item '{"ISBN": {"S": "978-0132350884"}, "Title": {"S": "Clean Code"}, "Author": {"S": "Robert C. Martin"}}'
# Your code here to add the book item

Need a hint?

Use aws dynamodb put-item with the --item JSON specifying the attributes and their types.

4

Query the Books table by ISBN

Write the AWS CLI command to query the Books table for the item with ISBN equal to "978-0132350884".

DynamoDB

aws dynamodb query --table-name Books --key-condition-expression "ISBN = :isbn" --expression-attribute-values '{":isbn": {"S": "978-0132350884"}}'
# Your code here to query the book by ISBN

Need a hint?

Use aws dynamodb query with --key-condition-expression and --expression-attribute-values to find the book by ISBN.