What Can Snowflake’s Time Travel Really Do For You?
Optimise your workflow with Snowflake’s time travel feature
One of the great features you have available in Snowflake is called “time travel” (documentation here), which allows you to set up your table(s) so that you can go back in time for up to 90 days. This may seem like just another “cool” feature, but it’s way more than that... This is a great way to improve your workflow saving you a lot of time and hassle. Let’s jump right into it.
Debug Your ETL Failures (with data “as it looked then”)
It’s Friday night, you’re at home watching Love Island (you know you do…), and at that same exact time the finance month-end reconciliation script is failing in Production. The weekend goes by. Monday morning you get to the office and there it is: a big red box, a bunch of alerts, and your favourite finance guy asking you for an update. You rerun the script, and it succeeds! Wait, how did that happen? What changed??
This is a typical “what? it worked? What am I missing??” scenario: not knowing why it went from failure to success means you may have a…