03 Oct 19 · npack · #Snowflake ·   Bookmark   ×

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);


posted on 03 Oct 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

AzharuddinKOct 04 03:12

Should Time Travel be a part of Backup Strategy ?

Also, it only works if the data is truncated and deleted. it wasn't working if we create or replace any new object 

Community Software by Hittly