Apache Iceberg Time Travel & Rollbacks in Trino

Apache Iceberg in Trino offers robust time travel and rollback features, allowing users to view and revert to previous table states through snapshots, enhancing data management capabilities on data lakehouses. Each change made to an Iceberg table generates a new snapshot, which can be accessed using SQL queries to review or revert operations like creation, insertion, and updates. The "for version as of" syntax enables users to select specific snapshots, while timeframes can retrieve older data states. Rollbacks permit reverting to previous table states if a snapshot hasn't been cleaned up, useful for correcting accidental data modifications. These capabilities bring database-like functionalities to object stores, significantly enhancing data management and recovery processes.