Time travel query syntax in Snowflake

Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period

See data as of timestamp:

select * from my_table 
at(timestamp => 'Mon, 01 May 2015 16:20:00 -0700'::timestamp);

See data from a table as of 5 minutes ago:

select * from my_table at(offset => -60*5);

nVector

posted on 03 Oct 19