Amazon Redshift supports UPDATE, DELETE, MERGE for Apache Iceberg tables
News
This article announces that Amazon Redshift now supports row-level UPDATE, DELETE, and MERGE operations on Apache Iceberg tables, enabling direct data manipulation without external processing engines.
- UPDATE, DELETE, and MERGE operations now work on partitioned and unpartitioned Iceberg tables
- Supports S3 Tables and common Iceberg partition transforms
- MERGE enables single-statement insert and update logic for data integration patterns
- Tables remain compatible with other Iceberg engines like EMR and Athena
- AWS Lake Formation permissions supported for Iceberg write operations
- Available in all AWS Regions where Redshift operates
This release simplifies data lake operations by allowing Redshift users to perform DML operations directly on Iceberg tables, reducing pipeline complexity and latency.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.