20 March 2019 · n-pacha ·       Add to Favorites   Report

Pitfalls of using Snowflake Time Travel as your database backup strategy

Snowflake Time Travel enables accessing historical data at any point within a defined period. You can go back up to 1 day in a standard edition and up to 90 days if you are on an enterprise edition. It's a powerful feature to see how the data looked at an instant of time. However, it cannot be a replacement for your database backup strategy. Here's the reason:

If you alter table to drop few columns, all the time travel data for those columns are lost. You cannot historically navigate to look at the data in those columns

Time travel works as long as the structure is not altered. So be mindful of this tiny drawback before you consider your data warehouse backup strategy. It's always good to take a clone instead of relying on Time-travel.

What do you use for backups in your organization?

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too