Filter expressions in DynamoDB - Mini Project: Build & Apply

Filter Items in DynamoDB Using Filter Expressions

📖 Scenario: You manage a DynamoDB table that stores information about books in a library. You want to find books that are currently available for borrowing.

🎯 Goal: Build a DynamoDB query that uses a filter expression to retrieve only the books where the available attribute is true.

📋 What You'll Learn

Create a dictionary called table representing the DynamoDB table with sample book items.

Add a filter expression variable called filter_expression to select books where available is true.

Write a query using the scan method with the filter expression to get only available books.

Complete the query setup by including the filter expression in the scan parameters.

💡 Why This Matters

🌍 Real World

Filtering data in DynamoDB tables is common when you want to retrieve only items that meet certain conditions, such as available products or active users.

💼 Career

Understanding filter expressions is essential for backend developers and database administrators working with AWS DynamoDB to optimize data retrieval and reduce costs.

1

Create the DynamoDB table data

Create a dictionary called table with a key Items containing a list of three book dictionaries. Each book dictionary must have these exact keys and values: {'title': 'Book A', 'author': 'Author 1', 'available': True}, {'title': 'Book B', 'author': 'Author 2', 'available': False}, and {'title': 'Book C', 'author': 'Author 3', 'available': True}.

DynamoDB

# Create the DynamoDB table data with three books
# Your code here

Hint

Use a dictionary with key 'Items' and a list of dictionaries for the books.

2

Define the filter expression

Create a variable called filter_expression and set it to the string 'available = :val' to filter books where the available attribute is true.

DynamoDB

table = {
    'Items': [
        {'title': 'Book A', 'author': 'Author 1', 'available': True},
        {'title': 'Book B', 'author': 'Author 2', 'available': False},
        {'title': 'Book C', 'author': 'Author 3', 'available': True}
    ]
}
# Define the filter expression to select available books
# Your code here

Hint

The filter expression is a string that compares available to a placeholder :val.

3

Write the scan query with filter expression

Create a dictionary called scan_params with keys FilterExpression set to filter_expression and ExpressionAttributeValues set to a dictionary with ':val' as True.

DynamoDB

table = {
    'Items': [
        {'title': 'Book A', 'author': 'Author 1', 'available': True},
        {'title': 'Book B', 'author': 'Author 2', 'available': False},
        {'title': 'Book C', 'author': 'Author 3', 'available': True}
    ]
}
filter_expression = 'available = :val'
# Create scan parameters with filter expression and attribute values
# Your code here

Hint

Use a dictionary with keys FilterExpression and ExpressionAttributeValues for the scan parameters.

4

Complete the scan query setup

Add a variable called result and set it to the result of calling table['Items'] filtered by the condition where the available attribute is True using the scan_params filter expression logic.

DynamoDB

table = {
    'Items': [
        {'title': 'Book A', 'author': 'Author 1', 'available': True},
        {'title': 'Book B', 'author': 'Author 2', 'available': False},
        {'title': 'Book C', 'author': 'Author 3', 'available': True}
    ]
}
filter_expression = 'available = :val'
scan_params = {
    'FilterExpression': filter_expression,
    'ExpressionAttributeValues': {':val': True}
}
# Filter the items manually to simulate scan with filter expression
# Your code here

Hint

Use a list comprehension to filter table['Items'] where available equals True.

Practice

1. What is the main purpose of a FilterExpression in a DynamoDB scan or query?

easy

A. To return only items that meet specific conditions after reading all data

B. To reduce the size of the table permanently

C. To speed up the write operations

D. To create new indexes automatically

Solution

1. Step 1: Understand what FilterExpression does

   A FilterExpression is used to specify conditions that items must meet to be returned after the scan or query reads the data.

2. Step 2: Differentiate from other operations

   It does not change the table or speed up writes; it only filters results after reading.

3. Final Answer:

   To return only items that meet specific conditions after reading all data -> Option A

4. Quick Check:

   FilterExpression filters results after reading [OK]

Hint: FilterExpression filters results after reading data [OK]

Common Mistakes:

• Thinking FilterExpression reduces read capacity usage
• Confusing FilterExpression with key condition
• Assuming it changes the table data

2. Which of the following is the correct syntax for a FilterExpression to find items where attribute status equals 'active' in DynamoDB?

easy

A. FilterExpression: "status = 'active'"

B. FilterExpression: "status == 'active'"

C. FilterExpression: "status equals 'active'"

D. FilterExpression: "status === 'active'"

Solution

1. Step 1: Recall DynamoDB FilterExpression syntax

   DynamoDB uses single equals sign (=) for equality in FilterExpressions.

2. Step 2: Check each option

   FilterExpression: "status = 'active'" uses correct syntax. The other options use invalid operators (==, equals, ===) or keywords.

3. Final Answer:

   FilterExpression: "status = 'active'" -> Option A

4. Quick Check:

   Use single equals (=) for equality in FilterExpression [OK]

Hint: Use single '=' for equality in FilterExpression [OK]

Common Mistakes:

• Using double or triple equals (==, ===)
• Writing 'equals' as a word
• Using incorrect operators

3. Given a DynamoDB table with items having attribute age, what will be the result of this scan with FilterExpression age < 30 if the table has ages 25, 30, 35, and 40?

medium

A. Items with ages 25 and 30

B. Items with ages 25 only

C. Items with ages 30, 35, and 40

D. Items with ages 35 and 40

Solution

1. Step 1: Understand the FilterExpression condition

   The condition is age < 30, meaning only items with age less than 30 pass the filter.

2. Step 2: Check which ages satisfy the condition

   From the list (25, 30, 35, 40), only 25 is less than 30.

3. Final Answer:

   Items with ages 25 only -> Option B

4. Quick Check:

   age < 30 means less than 30 [OK]

Hint: Remember < means strictly less than [OK]

Common Mistakes:

• Including age 30 when condition is less than 30
• Confusing < with <= operator
• Assuming filter changes data in table

4. You wrote this FilterExpression: contains(name, 'John') but it returns no results even though some items have 'John' in their name. What is the likely mistake?

medium

A. Using contains() instead of equals()

B. Not using ExpressionAttributeNames for reserved words

C. FilterExpression is case-sensitive and 'John' does not match 'john'

D. FilterExpression must be in uppercase

Solution

1. Step 1: Understand contains() behavior

   contains() checks if the attribute contains the exact substring, including case.

2. Step 2: Consider case sensitivity

   If the data has 'john' lowercase but the filter uses 'John' with uppercase J, no match occurs.

3. Step 3: Check other choices

   Using equals() instead of contains() is not the issue since contains() is appropriate for substrings; reserved words would cause a different error; FilterExpressions are not required to be uppercase.

4. Final Answer:

   FilterExpression is case-sensitive and 'John' does not match 'john' -> Option C

5. Quick Check:

   contains() is case-sensitive [OK]

Hint: Remember contains() is case-sensitive [OK]

Common Mistakes:

• Ignoring case sensitivity in contains()
• Not using ExpressionAttributeNames when needed
• Assuming contains() works like equals()

5. You want to scan a DynamoDB table to find items where score is greater than 50 and status is 'active'. Which FilterExpression correctly applies both conditions?

hard

A. FilterExpression: "score > 50, status = 'active'"

B. FilterExpression: "score > 50 OR status = 'active'"

C. FilterExpression: "score > 50 && status == 'active'"

D. FilterExpression: "score > 50 AND status = 'active'"

Solution

1. Step 1: Understand logical operators in FilterExpression

   DynamoDB uses uppercase AND and OR for combining conditions.

2. Step 2: Check each option's syntax

   FilterExpression: "score > 50 AND status = 'active'" uses correct syntax with AND and single equals. FilterExpression: "score > 50 OR status = 'active'" uses OR which is incorrect for both conditions. FilterExpression: "score > 50, status = 'active'" uses comma which is invalid. FilterExpression: "score > 50 && status == 'active'" uses && and double equals which are invalid.

3. Final Answer:

   FilterExpression: "score > 50 AND status = 'active'" -> Option D

4. Quick Check:

   Use AND in uppercase and single '=' for equality [OK]

Hint: Use uppercase AND and single '=' in FilterExpression [OK]

Common Mistakes:

• Using OR instead of AND for both conditions
• Using commas or && instead of AND
• Using double equals (==) instead of single equals (=)