Example
The following examples shows how to query a table based on the snapshot id.
Iceberg
SELECT * FROM datalake_iceberg_glue.vim.cdata FOR SNAPSHOT AS OF '6373759902296319074'; *** Query completed. 2 rows found. 12 columns returned. *** Total elapsed time was 2 seconds. price 1.61759576000000E 004 mileage 19095 make Saturn model L Series trim Lx300 Sedan 4D type Sedan cylinder 6 liter 3.00000000000000E 000 doors 4 cruise 1 sound 1 leather 0 price 1.57311329000000E 004 mileage 20484 make Saturn model L Series trim Lx300 Sedan 4D type Sedan cylinder 6 liter 3.00000000000000E 000 doors 4 cruise 1 sound 1 leather 0
Delta Lake
select * from datalake_deltalake.db1.tb1 for snapshot as of '2'; *** Query completed. 2 rows found. 2 columns returned. *** Total elapsed time was 6 seconds. col1 DTwo col2 2 col1 DOne col2 1