Time Travel Query based on Snapshot Id - Teradata Vantage

Example

The following examples show 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