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