Amazon Redshift supports UPDATE, DELETE, MERGE for Apache Iceberg tables

Amazon Redshift

Now supports row-level UPDATE, DELETE, and MERGE operations on Apache Iceberg tables. This allows customers using Iceberg to build interoperable data lakes to perform data manipulation language (DML) operations directly from Amazon Redshift, without moving data to external processing engines.

You can now run UPDATE, DELETE, and MERGE (UPSERT) statements on both partitioned and unpartitioned Iceberg tables, including S3 Tables. Supported Iceberg partition transforms include identity, bucket, truncate, year, month, day, and hour. MERGE enables combining insert and update logic in a single statement for common data integration patterns such as change data capture and slowly changing dimensions. Tables modified by Redshift are compatible with other Iceberg-compatible engines, including Amazon EMR and Amazon Athena, preserving cross-engine interoperability. AWS Lake Formation permissions are supported for Iceberg write operations.

What to do

• Visit the Writing to Apache Iceberg tables section in the Amazon Redshift Database Developer Guide.
• Review the SQL syntax for the new commands.

Source: AWS release notes

If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.