Update Iceberg table data

You can manage Iceberg table data directly on Athena by using INSERT, UPDATE, and DELETE queries. Each data management transaction produces a new snapshot, which can be queried using time travel. The UPDATE and DELETE statements follow the Iceberg format v2 row-level position delete specification and enforce snapshot isolation.

Note

The UPDATE, MERGE INTO, and DELETE FROM commands use the merge-on-read approach with positional deletes. The copy-on-write approach isn't currently supported in Athena SQL. Your queries won't fail as Athena will ignore such requests.

Use the following commands to perform data management operations on Iceberg tables.

Topics

• INSERT INTO

• DELETE

• UPDATE

• MERGE INTO