top of page

Blogs
Time Travel on Snowflake: UNDROP to the Rescue
I really like the Time Travel feature in Snowflake. It is very handy and absurdly simple. If you have incorrectly updated one of your Snowflake tables and if you know that your table was in the correct state at 9 am on Sun, Oct 13, 2019, then you can simply run the query: SELECT * FROM TABLE_NAME AT(TIMESTAMP => 'Sun, 13 Oct 2019 09:00:00 -0800'::TIMESTAMP); where -0800 refers to your time zone in relation to UTC. However, this query will not work if you dropped or replaced t

niket.b
Nov 12, 20192 min read
Â
Â
Â
bottom of page
