What is the MAXIMUM Time Travel retention period for a transient table?
What is the MAXIMUM Time Travel retention period for a transient table?
For transient tables, the maximum Time Travel retention period is 1 day. Transient tables in Snowflake are designed for temporary storage, with reduced data retention capabilities. This aligns with the 1-day retention period, distinguishing them from standard tables that can have a longer Time Travel retention period.
Time travel - 1 day Fail safe - 0 day
B. 1 day