Key condition expressions in DynamoDB - Mini Project: Build & Apply

Querying DynamoDB with Key Condition Expressions

📖 Scenario: You are managing a DynamoDB table that stores information about books in a library. Each book has a Category as the partition key and a BookID as the sort key. You want to query the table to find books in a specific category with certain conditions on the BookID.

🎯 Goal: Build a DynamoDB query using a key condition expression to retrieve books from a specific category where the BookID is greater than a given value.

📋 What You'll Learn

Create a dictionary called table representing the DynamoDB table name.

Create a variable called category with the exact string value 'Fiction'.

Write a key condition expression string called key_condition_expression that uses Category = :category_val AND BookID > :book_id_val.

Create an expression attribute values dictionary called expression_attribute_values with :category_val set to category and :book_id_val set to the number 100.

💡 Why This Matters

🌍 Real World

DynamoDB key condition expressions are used to efficiently query data by specifying conditions on the partition and sort keys, which is common in real-world applications like retrieving user data, orders, or inventory items.

💼 Career

Understanding key condition expressions is essential for backend developers and database administrators working with AWS DynamoDB to build scalable and performant applications.

1

Set up the DynamoDB table name and category

Create a dictionary called table with the key 'TableName' set to the string 'LibraryBooks'. Then create a variable called category and set it to the string 'Fiction'.

DynamoDB

# Create the table dictionary and category variable
# Your code here

Need a hint?

Use a dictionary for table with the exact key and value. Assign the string 'Fiction' to category.

2

Create the key condition expression string

Create a variable called key_condition_expression and set it to the string 'Category = :category_val AND BookID > :book_id_val'.

DynamoDB

table = {'TableName': 'LibraryBooks'}
category = 'Fiction'
# Create the key_condition_expression string
# Your code here

Need a hint?

Write the key condition expression exactly as shown, using placeholders :category_val and :book_id_val.

3

Create the expression attribute values dictionary

Create a dictionary called expression_attribute_values with the keys :category_val set to the variable category and :book_id_val set to the number 100.

DynamoDB

table = {'TableName': 'LibraryBooks'}
category = 'Fiction'
key_condition_expression = 'Category = :category_val AND BookID > :book_id_val'
# Create the expression_attribute_values dictionary
# Your code here

Need a hint?

Use the variable category for the value of :category_val and the number 100 for :book_id_val.

4

Combine all parts to prepare the query parameters

Create a dictionary called query_params that includes the keys TableName from table, KeyConditionExpression from key_condition_expression, and ExpressionAttributeValues from expression_attribute_values.

DynamoDB

table = {'TableName': 'LibraryBooks'}
category = 'Fiction'
key_condition_expression = 'Category = :category_val AND BookID > :book_id_val'
expression_attribute_values = {':category_val': category, ':book_id_val': 100}
# Create the query_params dictionary combining all parts
# Your code here

Need a hint?

Use the values from the variables table, key_condition_expression, and expression_attribute_values to build query_params.