UpdateItem basics in DynamoDB - Step-by-Step Execution

Concept Flow - UpdateItem basics

Start UpdateItem Request

↓

Identify Table & Key

↓

Check Item Exists?

No→Create New Item (if allowed)

Yes↓

Apply Update Expression

↓

Save Updated Item

↓

Return Success or Updated Attributes

UpdateItem finds the item by key, applies changes, saves it, and returns the result.

Execution Sample

DynamoDB

UpdateItem {
  TableName: 'Users',
  Key: {UserId: '123'},
  UpdateExpression: 'SET Age = Age + :inc',
  ExpressionAttributeValues: {':inc': 1}
}

This updates the Age attribute of user 123 by adding 1.

Execution Table

Step	Action	Evaluation	Result
1	Receive UpdateItem request	Table: Users, Key: UserId=123	Proceed to find item
2	Check if item exists	Item with UserId=123 found	Item found, continue update
3	Parse UpdateExpression	SET Age = Age + :inc	Ready to update Age
4	Evaluate ExpressionAttributeValues	:inc = 1	Value 1 ready for addition
5	Calculate new Age	Old Age = 30, New Age = 30 + 1	New Age = 31
6	Save updated item	Age updated to 31	Item saved successfully
7	Return response	Return updated attributes	Success with Age=31

💡 Update complete, item saved with new Age value

Variable Tracker

Variable	Start	After Step 5	Final
Age	30	31	31
:inc	N/A	1	1

Key Moments - 3 Insights

What happens if the item with the given key does not exist?

If the item does not exist, DynamoDB can create a new item only if the update expression allows it; otherwise, the update fails. In the execution_table row 2, the item was found, so update proceeds.

How does DynamoDB know what value to add to Age?

The value to add comes from ExpressionAttributeValues, shown in execution_table row 4 where ':inc' is set to 1.

When is the item actually saved with the new value?

The item is saved after calculating the new value, as shown in execution_table row 6.

Visual Quiz - 3 Questions

Look at the execution_table, what is the Age value after step 5?

A 31

B 30

C 29

D Undefined

💡 Hint

Check the 'Calculate new Age' action in row 5 of execution_table.

At which step does DynamoDB save the updated item?

A Step 5

B Step 6

C Step 4

D Step 7

💡 Hint

Look for 'Save updated item' action in execution_table.

If the item was not found at step 2, what would happen next?

A Update proceeds normally

B UpdateExpression is ignored

C Item is created only if allowed by update expression

D DynamoDB returns success without changes

💡 Hint

Refer to concept_flow where 'Check Item Exists?' leads to 'Create New Item (if allowed)' if No.

Concept Snapshot

UpdateItem basics:
- Specify TableName and Key to find item
- Use UpdateExpression to define changes
- ExpressionAttributeValues provide values
- DynamoDB applies update and saves item
- Returns updated attributes or success status

Full Transcript

The UpdateItem operation in DynamoDB starts by receiving a request with the table name and key identifying the item. It checks if the item exists. If found, it parses the update expression and evaluates any attribute values. Then it calculates the new attribute values, saves the updated item, and returns success with updated attributes. If the item does not exist, DynamoDB can create it if allowed by the update expression. This process ensures only the specified attributes are changed without replacing the whole item.

Practice

1. What does the UpdateItem operation in DynamoDB do?

easy

A. It reads all items from the table.

B. It deletes the entire item from the table.

C. It creates a new table in DynamoDB.

D. It changes specific attributes of an item without replacing the whole item.

Solution

1. Step 1: Understand UpdateItem purpose

   The UpdateItem operation is designed to modify parts of an existing item, not the entire item.

2. Step 2: Compare with other operations

   Deleting an item or creating a table are different operations, so they don't match UpdateItem's function.

3. Final Answer:

   It changes specific attributes of an item without replacing the whole item. -> Option D

4. Quick Check:

   UpdateItem modifies parts of an item [OK]

Hint: UpdateItem changes parts, not whole items [OK]

Common Mistakes:

• Thinking UpdateItem deletes items
• Confusing UpdateItem with CreateTable
• Assuming UpdateItem reads data only

2. Which of the following is the correct way to specify an update expression in DynamoDB's UpdateItem?

easy

A. UpdateExpression: 'REMOVE :value'

B. UpdateExpression: 'ADD #name = :value'

C. UpdateExpression: 'SET #name = :value'

D. UpdateExpression: 'DELETE #name = :value'

Solution

1. Step 1: Identify valid UpdateExpression syntax

   The 'SET' keyword is used to assign a new value to an attribute, correctly written as 'SET #name = :value'.

2. Step 2: Check other options for syntax errors

   'ADD' requires a space before the value and no '=' sign; 'REMOVE' does not take a value; 'DELETE' syntax is incorrect here.

3. Final Answer:

   UpdateExpression: 'SET #name = :value' -> Option C

4. Quick Check:

   Use SET with '=' for updates [OK]

Hint: Use 'SET #attr = :val' for updates [OK]

Common Mistakes:

• Using '=' with ADD or REMOVE
• Missing '#' for attribute names
• Incorrect DELETE syntax

3. Given the following UpdateItem call:

{
  TableName: 'Users',
  Key: { 'UserId': { S: '123' } },
  UpdateExpression: 'SET Age = Age + :inc',
  ExpressionAttributeValues: { ':inc': { N: '1' } }
}

What will happen to the Age attribute of the item with UserId '123'?

medium

A. The operation will fail with a syntax error.

B. Age will be incremented by 1.

C. Age will be deleted.

D. Age will be set to 1.

Solution

1. Step 1: Analyze the UpdateExpression

   The expression 'SET Age = Age + :inc' means increase the current Age by the value of ':inc', which is 1.

2. Step 2: Understand the effect on the item

   This will add 1 to the existing Age attribute, not replace or delete it.

3. Final Answer:

   Age will be incremented by 1. -> Option B

4. Quick Check:

   SET with addition increments attribute [OK]

Hint: SET with '+ :value' adds to number attributes [OK]

Common Mistakes:

• Thinking Age resets to 1
• Assuming Age is deleted
• Expecting syntax error from addition

4. You wrote this UpdateItem call:

{
  TableName: 'Products',
  Key: { 'ProductId': { S: 'p001' } },
  UpdateExpression: 'SET Count = :newCount',
  ExpressionAttributeValues: { ':newCount': { N: '20' } },
  ExpressionAttributeNames: { '#Count': 'Count' }
}

But the update fails. What is the likely error?

medium

A. You used ExpressionAttributeNames but did not use '#Count' in UpdateExpression.

B. The Key is missing the sort key attribute.

C. The value ':newCount' must be a string, not a number.

D. UpdateExpression cannot use SET to update numeric attributes.

Solution

1. Step 1: Check usage of ExpressionAttributeNames

   You defined '#Count' in ExpressionAttributeNames but did not use '#Count' in UpdateExpression; you used 'Count' directly instead.

2. Step 2: Understand attribute name substitution

   When you define ExpressionAttributeNames, you must use the placeholder '#Count' in UpdateExpression to avoid reserved word conflicts.

3. Final Answer:

   You used ExpressionAttributeNames but did not use '#Count' in UpdateExpression. -> Option A

4. Quick Check:

   Use '#name' in UpdateExpression if defined [OK]

Hint: Use '#attr' in UpdateExpression if defined [OK]

Common Mistakes:

• Ignoring ExpressionAttributeNames usage
• Assuming numeric values must be strings
• Thinking SET can't update numbers

5. You want to remove the attribute Discount from an item with OrderId '789' using UpdateItem. Which is the correct UpdateExpression and parameters?

hard

A. UpdateExpression: 'REMOVE Discount', Key: { 'OrderId': { S: '789' } }

B. UpdateExpression: 'SET Discount = :null', ExpressionAttributeValues: { ':null': { NULL: true } }

C. UpdateExpression: 'DELETE Discount', Key: { 'OrderId': { S: '789' } }

D. UpdateExpression: 'REMOVE :Discount', ExpressionAttributeValues: { ':Discount': { S: 'Discount' } }

Solution

1. Step 1: Identify correct syntax to remove attribute

   The 'REMOVE' keyword followed by the attribute name removes that attribute from the item.

2. Step 2: Check other options for errors

   UpdateExpression: 'SET Discount = :null', ExpressionAttributeValues: { ':null': { NULL: true } } tries to set attribute to null which does not remove it; UpdateExpression: 'DELETE Discount', Key: { 'OrderId': { S: '789' } } uses DELETE incorrectly; UpdateExpression: 'REMOVE :Discount', ExpressionAttributeValues: { ':Discount': { S: 'Discount' } } uses placeholder incorrectly with REMOVE.

3. Final Answer:

   UpdateExpression: 'REMOVE Discount', Key: { 'OrderId': { S: '789' } } -> Option A

4. Quick Check:

   Use REMOVE with attribute name to delete attribute [OK]

Hint: Use REMOVE attributeName to delete attribute [OK]

Common Mistakes:

• Using SET with NULL to remove attribute
• Using DELETE keyword incorrectly
• Using placeholders with REMOVE without #