What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
The Fail-safe period for a transient table in the Snowflake Enterprise edition and higher is 0 days. Transient tables are similar to permanent tables in terms of functionality, but they do not have a Fail-safe period, meaning there is no period during which Snowflake retains the data for disaster recovery purposes. This helps manage storage costs since there are no additional charges for maintaining Fail-safe data.
Temporary and Transient Tables¶ To help manage the storage costs associated with Time Travel and Fail-safe, Snowflake provides two table types, temporary and transient, which do not incur the same fees as standard (i.e. permanent) tables: Transient tables can have a Time Travel retention period of either 0 or 1 day. Temporary tables can also have a Time Travel retention period of 0 or 1 day; however, this retention period ends as soon as the table is dropped or the session in which the table was created ends. Transient and temporary tables have no Fail-safe period. As a result, the maximum
Zero is the answer
Similar to permanent tables, transient tables contribute to the overall storage charges that Snowflake bills your account; however, because transient tables do not utilize Fail-safe, there are no Fail-safe costs (i.e. the costs associated with maintaining the data required for Fail-safe disaster recovery).
https://docs.snowflake.com/en/user-guide/tables-temp-transient Transient tables are similar to permanent tables with the key difference that they do not have a Fail-safe period
Failsafe is 0 for temporary and transient