Amazon Redshift supports UPDATE, DELETE, MERGE for Apache Iceberg tables
Amazon Web Services has expanded Amazon Redshift's capabilities by adding support for row-level UPDATE, DELETE, and MERGE operations on Apache Iceberg tables. The enhancement allows customers to perform data manipulation language (DML) operations directly within Redshift without requiring external processing engines, addressing a previous limitation that forced users to rely on separate systems for modifying individual rows in Iceberg tables. The new functionality works with both partitioned and unpartitioned Iceberg tables, including S3 Tables, and supports various Iceberg partition transforms such as identity, bucket, truncate, and time-based partitioning (year, month, day, hour). The MERGE operation enables users to combine insert and update logic in a single statement, streamlining common data integration patterns like change data capture and slowly changing dimensions. Tables modified through Redshift maintain compatibility with other Iceberg-compatible engines including Amazon EMR and Amazon Athena, preserving the cross-engine interoperability that makes Iceberg valuable for data lake architectures. The feature includes support for AWS Lake Formation permissions and is now available across all AWS regions where Redshift operates.
Why It Matters
This update significantly reduces complexity in data lake architectures by eliminating the need to move data between different engines for row-level modifications. For organizations using Apache Iceberg as their table format standard, this means faster data pipeline execution and simplified architecture, particularly for real-time analytics and data integration workflows. The maintained cross-engine compatibility ensures that teams can continue using their preferred tools while benefiting from Redshift's performance optimizations.
This summary is generated using AI analysis of the original press release. Always refer to the original source for complete details.