What is the maximum duration of data retention using Time Travel in Snowflake for standard accounts?
For Snowflake Standard Edition accounts, the maximum Time Travel retention period is1 day(24 hours). Time Travel allows users to query historical data, restore dropped objects, and clone objects at a point in time. Although the retention period can be adjusted at the account, database, schema, or table level, Standard Edition restricts the upper limit to 1 day. A value of 0 disables Time Travel entirely. A 7-day retention period applies to Fail-safe, not Time Travel, and Fail-safe is a disaster-recovery mechanism managed exclusively by Snowflake. The 90-day Time Travel retention is available only for Enterprise Edition and above. Therefore, the correct maximum retention period for Standard Edition is 1 day.
=======================================
Currently there are no comments in this discussion, be the first to comment!