In this blog, you will gain an understanding of Fail-Safe in Snowflake, its limitations, and how to view Fail-Safe storage for your account.
What is Fail-safe in Snowflake?
The fail-safe feature provides a non-configurable
7-day period during which historical data may be recoverable by Snowflake. This period starts immediately after the Time Travel retention period ends.
To recover data using Fail Safe, you need to contact Snowflake support. Snowflake support will work with you to determine if the data is recoverable and to restore the data.
Note: Transient and temporary tables have no Fail-safe period.
Viewing Fail-safe Storage for Your Account
In the Snowflake web interface, account administrators can view the total data storage for their account, including historical data in Fail-safe.
Here are some limitations of Fail Safe:
- It applies only to data that is lost after the Time Travel retention period has expired.
- It is not a guaranteed recovery solution. Snowflake may not be able to recover all data, and the recovered data may be corrupted.
- Data recovery using Fail Safe can be a time-consuming process.
Overall, Fail Safe is a valuable tool for protecting your data from loss. It is important to note that Fail Safe is not a replacement for Time Travel. You should still use Time Travel to retain your data for a period of time that meets your compliance and business needs.
Thank you for reading this post, and I hope you enjoyed it!
Refer Post: Time Travel in Snowflake