Time Travel Query based on Snapshot Id - Teradata Vantage

Apache Iceberg and Delta Lake Open Table Format on VantageCloud Lake Getting Started

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-03
dita:mapPath
bsr1702324250454.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
bsr1702324250454

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