Difference between DynamoDb PutItem vs UpdateItem?

Question

Based on DynamoDb documentation why would anyone use updateItem instead of putItem?

---

• PutItem - Writes a single item to a table. If an item with the same primary key exists in the table, the operation replaces the item. For calculating provisioned throughput consumption, the item size that matters is the larger of the two.
• UpdateItem - Modifies a single item in the table. DynamoDB considers the size of the item as it appears before and after the update. The provisioned throughput consumed reflects the larger of these item sizes. Even if you update just a subset of the item's attributes, UpdateItem will still consume the full amount of provisioned throughput (the larger of the "before" and "after" item sizes).

Answer 1

The main difference between the two is, PutItem will Replace an entire item while UpdateItem will Update it.

Eg.

I have an item like:

userId = 1
Name= ABC
Gender= Male

If I use PUT item with

UserId = 1
Country = India

This will replace Name and Gender and now new Item is UserId and Country. While if you want to update an item from Name = ABC to Name = 123 you have to use UpdateItem

You can use Put item to update it but you need to send all the parameters instead of just the Parameter you want to update because it Replaces the item with the new attribute.(Internally it Deletes the item and Add new item)

Hope this make sense.

Answer 2

PutItem overwrites the whole item (all attributes) with the new version being passed while UpdateItem will only Update the passed attributes

Performance: PutItem may affect on the performance if you overwrite the entire item so often as it involves more operations than UpdateItem FindItem, DeleteOldVersion, and AddNewVersion

From cost prospective, it is different as well:

AWS calculates the cost based on used read/write capacity units that are completely tied to the size of the item being overwritten/updated.

In case of PutItem, the size will be the larger of the new and old versions of the item. For example, replacing a 2 KB item with a 1 KB, It will consume 2 WCUs however subsequent requests will only use 1 WCU. so if you're overwriting so often and the size of the item changes heavily that will calculate always the larger version of the item and affects on the cost.

In case of modifying items using UpdateItem, the size includes all of the item’s pre-existing attributes, not the larger version like PutItem :) but also not just the ones being added or updated :(

Answer 3

Slight correction in the above answer: Even the update item API takes the larger of the two item sizes(pre-update and post-update) into consideration. See documentation here.