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.