Getting started with Apache Iceberg write support in Amazon Redshift – Part 2
Big Data Blog
This article demonstrates DELETE, UPDATE, and MERGE operations for Apache Iceberg tables in Amazon Redshift, enabling row-level data modifications while maintaining ACID compliance.
- MERGE operation synchronizes orders data using upsert patterns between staging and production tables
- UPDATE operation modifies customer records based on conditions from reference tables
- DELETE operation removes customer records based on opt-out indicators
- All operations maintain transactional consistency across S3 and S3 Tables storage
- Results are immediately queryable by other analytics engines like EMR and Athena
- Table maintenance recommended after multiple UPDATE/DELETE operations for performance optimization
Amazon Redshift now enables comprehensive data manipulation on Iceberg tables, combining warehouse performance with data lake scalability for flexible row-level modifications.
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
Nov 26
2025
2025
Getting started with Apache Iceberg write support in Amazon Redshift
Nov 17
2025
2025
Amazon Redshift now supports writing to Apache Iceberg tables
Apr 23
2026
2026
Amazon Redshift supports UPDATE, DELETE, MERGE for Apache Iceberg tables
Dec 17
2025
2025
Best practices for querying Apache Iceberg data with Amazon Redshift
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.