Running time travel queries
You query historical snapshots of data using the FOR SYSTEM_TIME AS OF '<timestamp>' FOR SYSTEM_VERSION AS OF <snapshot_id> clauses in a select statement. You see how to use AS OF to specify a snapshot of your Iceberg data at a certain time.
You can inspect the history of an Iceberg table to see the snapshots. You can query the metadata of the Iceberg table using a SELECT ... AS OF statement to run time travel queries. You use history information from a query of the database to identify and validate snapshots, and then query a specific snapshot AS OF a certain Timestamp value.
- You must be aware of the table history.
However, this can include commits that have been rolled back.
- You must have access to valid snapshots.
- You must meet the prerequisites to query Iceberg tables mentioned earlier.
View the table history.
SELECT * FROM db.table.history;
Check the valid snapshots of the table.
SELECT * FROM db.table.snapshots;
Query a specific snapshot by providing the timestamp and snapshot_id.
SELECT * FROM T FOR SYSTEM_TIME AS OF <TIMESTAMP>; SELECT * FROM t FOR SYSTEM_VERSION AS OF <SNAPSHOT_ID>;