DELETE expression for set removal in DynamoDB - Mini Project: Build & Apply

DELETE Expression for Set Removal in DynamoDB

📖 Scenario: You manage a DynamoDB table that stores user profiles. Each profile has a set of favorite fruits. Sometimes, users want to remove certain fruits from their favorites.

🎯 Goal: Build a DynamoDB update expression that removes specific fruits from a user's favorite fruits set using the DELETE expression.

📋 What You'll Learn

Create a dictionary called item_key with the exact key 'UserID': 'user123' to identify the user.

Create a variable called update_expression with the exact string 'DELETE FavoriteFruits :fruitsToRemove'.

Create a dictionary called expression_attribute_values with the exact key ':fruitsToRemove' mapped to a set containing 'Apple' and 'Banana'.

Create a dictionary called params that combines TableName, Key, UpdateExpression, and ExpressionAttributeValues with the exact values specified.

💡 Why This Matters

🌍 Real World

Removing specific items from a user's set attribute in a DynamoDB table is common in apps that track user preferences, like favorite fruits, tags, or skills.

💼 Career

Understanding how to use DynamoDB update expressions with DELETE is important for backend developers working with AWS to efficiently modify set attributes without replacing the entire item.

1

Create the item key dictionary

Create a dictionary called item_key with the exact entry 'UserID': 'user123' to identify the user whose favorite fruits will be updated.

DynamoDB

# Create the item_key dictionary with 'UserID': 'user123'
# Your code here

Need a hint?

Use curly braces to create a dictionary with the key 'UserID' and value 'user123'.

2

Create the update expression string

Create a variable called update_expression and set it to the exact string 'DELETE FavoriteFruits :fruitsToRemove' to specify the removal operation.

DynamoDB

item_key = {'UserID': 'user123'}
# Create the update_expression string
# Your code here

Need a hint?

Assign the exact string to update_expression including the word DELETE and the attribute name.

3

Create the expression attribute values dictionary

Create a dictionary called expression_attribute_values with the exact key ':fruitsToRemove' mapped to a set containing the strings 'Apple' and 'Banana'.

DynamoDB

item_key = {'UserID': 'user123'}
update_expression = 'DELETE FavoriteFruits :fruitsToRemove'
# Create expression_attribute_values with ':fruitsToRemove' set to {'Apple', 'Banana'}
# Your code here

Need a hint?

Use curly braces to create a set with 'Apple' and 'Banana' as values for the key ':fruitsToRemove'.

4

Combine all parameters into the params dictionary

Create a dictionary called params with the exact keys and values: 'TableName' set to 'UserProfiles', 'Key' set to item_key, 'UpdateExpression' set to update_expression, and 'ExpressionAttributeValues' set to expression_attribute_values.

DynamoDB

item_key = {'UserID': 'user123'}
update_expression = 'DELETE FavoriteFruits :fruitsToRemove'
expression_attribute_values = {':fruitsToRemove': {'Apple', 'Banana'}}
# Create params dictionary with TableName, Key, UpdateExpression, and ExpressionAttributeValues
# Your code here

Need a hint?

Use a dictionary with the exact keys and assign the variables created in previous steps as values.