Iceberg time travel

Read an Iceberg table as it existed at a point in time.

Krishiv uses FOR SYSTEM_TIME AS OF to select a historical snapshot. The closest snapshot at or before the given timestamp is returned.

SELECT customer_id, SUM(amount) AS total
FROM my_catalog.warehouse.orders
FOR SYSTEM_TIME AS OF TIMESTAMP '2024-06-01 00:00:00'
GROUP BY customer_id;

Notes

Only Iceberg tables registered under a KrishivCatalog support time travel.
The snapshot selection rule is "at or before" the given timestamp. If no snapshot exists at or before, the query errors.
Multiple time-travel refs in the same query are resolved independently.

See the AS-OF Queries reference for the full syntax and the Iceberg connector for catalog setup.