Skip to main content

Fail safe

✅ What is Fail-safe in Snowflake?​

Fail-safe is a last-resort data recovery feature provided by Snowflake. It’s an extra safeguard after Time Travel has expired.


📌 Key Points:​

  • Duration: Fail-safe data is retained for 7 days after the Time Travel period ends.

  • Use Case: It’s used only for emergency data recovery by Snowflake engineers. You (as a user) cannot access fail-safe data directly.

  • Not for Regular Data Recovery: Unlike Time Travel, you cannot query, clone, or restore data yourself from Fail-safe.


⏰ Timeline:​

  1. Active Data
  2. Time Travel Period (0 to 90 days, depending on your Snowflake edition)
  3. Fail-safe (7 days)
  4. Permanent Deletion

🔎 Why is it Important?​

Fail-safe helps Snowflake protect against catastrophic failures (like hardware issues or data corruption on their side). It ensures that data can still be restored by Snowflake engineers during this 7-day period.


⚠️ Important Notes:​

  • No User Access: Only Snowflake’s internal team can perform recovery.
  • Not a Backup Strategy: Fail-safe should not be used as a replacement for your own backup or disaster recovery plan.

🚀 Summary:​

  • Time Travel = you can recover data yourself.
  • Fail-safe = Snowflake-only recovery, for emergencies.
  • After 7 days of Fail-safe, data is gone forever.

Let me know if you’d like to see a diagram or typical scenario!