Pitfalls of using Snowflake Time Travel as your database backup strategy

404

nVector

posted on 20 Mar 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

Post Comment

AzharuddinK16-May-19

We did Snowflake Migration recently and ran the DDL commands for creation of the table in the old instance itself instead of new instance. And we lost all the data. Time Travel also didn't help in this case. What is your startegy for backup of your databases. ?

ReplyMore..ReportDelete

nVector16-May-19

True, once the structure changes / overwritten, we lose the time travel capabilities. Its good to take daily clones and monthly file exports to s3 buckets would be an additional layer of protection

ReplyMore..ReportDelete