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:
- Active Data
- Time Travel Period (0 to 90 days, depending on your Snowflake edition)
- Fail-safe (7 days)
- 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!