DELETE expression for set removal in DynamoDB - Step-by-Step Execution

Concept Flow - DELETE expression for set removal

Start with existing item

↓

Identify set attribute

↓

Specify elements to remove in DELETE expression

↓

Execute UpdateItem with DELETE

↓

DynamoDB removes specified elements from set

↓

Return updated item or success confirmation

This flow shows how DynamoDB removes specific elements from a set attribute using the DELETE update expression.

Execution Sample

DynamoDB

UpdateItem {
  Key: {UserId: "123"},
  UpdateExpression: "DELETE favoriteColors :colorsToRemove",
  ExpressionAttributeValues: {":colorsToRemove": {"Red", "Blue"}}
}

This code removes "Red" and "Blue" from the favoriteColors set of the user with UserId "123".

Execution Table

Step	Action	Set Before	Elements To Remove	Set After	Result
1	Start with item	{"favoriteColors": {"Red", "Green", "Blue", "Yellow"}}	-	{"Red", "Green", "Blue", "Yellow"}	Initial set has 4 colors
2	Prepare DELETE expression	-	{"Red", "Blue"}	-	Specify colors to remove
3	Execute UpdateItem with DELETE	{"Red", "Green", "Blue", "Yellow"}	{"Red", "Blue"}	{"Green", "Yellow"}	Red and Blue removed from set
4	Return updated item	{"Green", "Yellow"}	-	{"Green", "Yellow"}	Update successful, set updated

💡 All specified elements removed; no more elements to delete

Variable Tracker

Variable	Start	After Step 1	After Step 3	Final
favoriteColors	{"Red", "Green", "Blue", "Yellow"}	{"Red", "Green", "Blue", "Yellow"}	{"Green", "Yellow"}	{"Green", "Yellow"}
:colorsToRemove	-	{"Red", "Blue"}	{"Red", "Blue"}	{"Red", "Blue"}

Key Moments - 2 Insights

Why does the DELETE expression only remove specified elements and not the whole set?

Because the DELETE expression in DynamoDB removes only the elements listed in the expression from the set attribute, leaving other elements intact, as shown in execution_table step 3.

What happens if the elements to remove are not in the set?

DynamoDB ignores elements not present in the set, so the set remains unchanged. This is implied by the execution flow where only existing elements are removed.

Visual Quiz - 3 Questions

Look at the execution_table, what is the favoriteColors set after step 3?

A {"Red", "Green", "Blue", "Yellow"}

B {"Red", "Blue"}

C {"Green", "Yellow"}

D {}

💡 Hint

Check the 'Set After' column in row for step 3 in execution_table

At which step does DynamoDB remove the specified elements from the set?

A Step 3

B Step 2

C Step 1

D Step 4

💡 Hint

Look at the 'Action' and 'Result' columns in execution_table to find when removal happens

If we tried to remove "Purple" which is not in the set, what would happen?

A The set becomes empty

B The set remains unchanged

C DynamoDB throws an error

D All elements are removed

💡 Hint

Refer to key_moments explanation about removing elements not present in the set

Concept Snapshot

DELETE expression in DynamoDB removes specified elements from a set attribute.
Syntax: UpdateExpression: "DELETE setAttribute :elementsToRemove"
Only elements in the set are removed; others ignored.
Useful for updating sets without replacing entire attribute.
Requires ExpressionAttributeValues to specify elements to remove.

Full Transcript

This visual execution trace shows how the DELETE expression works in DynamoDB to remove elements from a set attribute. Starting with an item that has a set of colors, the DELETE expression specifies which colors to remove. When the UpdateItem operation runs, DynamoDB removes only those specified colors from the set, leaving others intact. The execution table tracks the set before and after removal, confirming the correct elements are deleted. Key moments clarify that only listed elements are removed and that trying to remove elements not in the set does nothing. The quiz tests understanding of the set state at each step and behavior when removing non-existent elements. The snapshot summarizes the syntax and behavior for quick reference.