BatchWriteItem in DynamoDB - Mini Project: Build & Apply

Batch Writing Items in DynamoDB

📖 Scenario: You are managing a small online bookstore database using DynamoDB. You want to add multiple new books to your Books table efficiently in one go.

🎯 Goal: Build a batch write request to add multiple book items to the Books table using DynamoDB's BatchWriteItem operation.

📋 What You'll Learn

Create a list of book items with exact attributes

Set up the request structure for batch writing

Use the BatchWriteItem format with PutRequest for each book

Complete the batch write request JSON structure

💡 Why This Matters

🌍 Real World

Batch writing is used in real applications to efficiently add or remove multiple items in DynamoDB with fewer network calls.

💼 Career

Understanding BatchWriteItem is important for backend developers and database engineers working with AWS DynamoDB to optimize data operations.

1

Create the list of book items

Create a variable called books as a list containing these exact dictionaries representing books: {"ISBN": "978-0132350884", "Title": "Clean Code", "Author": "Robert C. Martin"}, {"ISBN": "978-0201616224", "Title": "The Pragmatic Programmer", "Author": "Andrew Hunt"}, and {"ISBN": "978-0131103627", "Title": "The C Programming Language", "Author": "Brian W. Kernighan"}.

DynamoDB

# Create the list of book items called books
# Your code here

Need a hint?

Use a list with dictionaries for each book. Each dictionary must have keys ISBN, Title, and Author with the exact values.

2

Set the table name for batch write

Create a variable called table_name and set it to the string "Books".

DynamoDB

books = [
    {"ISBN": "978-0132350884", "Title": "Clean Code", "Author": "Robert C. Martin"},
    {"ISBN": "978-0201616224", "Title": "The Pragmatic Programmer", "Author": "Andrew Hunt"},
    {"ISBN": "978-0131103627", "Title": "The C Programming Language", "Author": "Brian W. Kernighan"}
]
# Create a variable called table_name and set it to "Books"
# Your code here

Need a hint?

Just assign the string "Books" to the variable table_name.

3

Build the batch write request items

Create a variable called request_items as a dictionary with the key as table_name and the value as a list of dictionaries. Each dictionary in the list should have a key PutRequest whose value is another dictionary with key Item set to the corresponding book dictionary from books. Use a list comprehension with books to build this structure.

DynamoDB

books = [
    {"ISBN": "978-0132350884", "Title": "Clean Code", "Author": "Robert C. Martin"},
    {"ISBN": "978-0201616224", "Title": "The Pragmatic Programmer", "Author": "Andrew Hunt"},
    {"ISBN": "978-0131103627", "Title": "The C Programming Language", "Author": "Brian W. Kernighan"}
]
table_name = "Books"
# Create request_items dictionary for BatchWriteItem with PutRequest for each book
# Your code here

Need a hint?

Use a dictionary with table_name as key and a list comprehension to create PutRequest dictionaries for each book.

4

Complete the BatchWriteItem request structure

Create a variable called batch_write_request as a dictionary with the key RequestItems set to the request_items dictionary.

DynamoDB

books = [
    {"ISBN": "978-0132350884", "Title": "Clean Code", "Author": "Robert C. Martin"},
    {"ISBN": "978-0201616224", "Title": "The Pragmatic Programmer", "Author": "Andrew Hunt"},
    {"ISBN": "978-0131103627", "Title": "The C Programming Language", "Author": "Brian W. Kernighan"}
]
table_name = "Books"
request_items = {
    table_name: [
        {"PutRequest": {"Item": book}} for book in books
    ]
}
# Create batch_write_request dictionary with key 'RequestItems' set to request_items
# Your code here

Need a hint?

Wrap the request_items dictionary inside another dictionary with key RequestItems.