From the course: Snowflake SnowPro Core Cert Prep

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Fail safe

Fail safe - Snowflake Tutorial

From the course: Snowflake SnowPro Core Cert Prep

Start my 1-month free trial Buy for my team

Fail safe

“

Next, we're going to talk about fail-safe. So think about this as a last chance saloon where your data rests for a few days before finally disappearing forever. So after the data-retention period associated with time travel ends, data can't be viewed within your account anymore. But that's not the end of the story because there's one final resting point for your data, which you can't see or access directly. And for a further, non-configurable seven days after data leaves the database, data from permanent objects ends up in something called a fail-safe. So if you can't see the data in fail-safe, then who can? Well, only Snowflake employees can access the fail-safe, so it may take several hours to recover data from this area. And Snowflake itself states that it's provided on a best-endeavor basis, so you should not rely on this functionality as part of your disaster recovery scenario. Bear in mind, for the exam, transient and temporary tables do not have a fail-safe period associated…

Contents