What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

Question

Options

• A0 days
• B1 day
• C7 days
• D14 days

• A
  90% (35)
• B
  3% (1)
• C
  3% (1)
• D
  5% (2)

Explanation

Transient tables have a Fail-safe period of 0 days - meaning there is no Fail-safe protection at all for transient tables, regardless of the Snowflake edition (Standard, Enterprise, Business Critical, etc.). This is by design: transient tables are intended for intermediate or short-lived data where reduced storage costs are preferred over full recoverability. Permanent tables have a 7-day Fail-safe period. Transient tables do support Time Travel (0 or 1 day), but the Fail-safe window is always zero.

No community discussion yet for this question.