Amazon Redshift now supports multi-statement transactions, conflict resolution, and time travel for Apache Iceberg

Amazon Redshift Updates
Amazon Redshift now supports multi-statement transactions, automatic write-conflict resolution, and time travel for Apache Iceberg tables. This allows for running multi-step, concurrent transformation pipelines directly on Iceberg tables and auditing the results with expected transaction semantics.
New Features
- Multi-statement transactions: Group several statements in a single BEGIN…COMMIT statement and publish them as one atomic Iceberg snapshot.
- Automatic write-conflict resolution: Concurrent writes can commit together when their changes don't overlap, instead of failing and retrying.
- Time travel: Query a table as it existed at a past point in time with AS OF TIMESTAMP.
What to do
- See the AWS release notes for more details.
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.



