Time Travel cannot be disabled for an account. For more information about storage charges, see Storage Costs for Time Travel and Fail-safe. Note that extended data retention requires additional storage which will be reflected in your monthly
INTIME USER GUIDE UPGRADE
However, you may wish to upgrade to Snowflake Enterprise Edition to enable configuring longer data retention periods of up to 90 daysįor databases, schemas, and tables. It is automatically enabled with the standard, 1-day retention period. No tasks are required to enable Time Travel. Period for an object is determined by MAX(DATA_RETENTION_TIME_IN_DAYS, MIN_DATA_RETENTION_TIME_IN_DAYS). When this parameter is set at the account level, the effective minimum data retention May change the effective data retention time. This parameter does not alter or replace the DATA_RETENTION_TIME_IN_DAYS parameter value. The MIN_DATA_RETENTION_TIME_IN_DAYS account parameter can be set by users with the ACCOUNTADMIN role to set a minimum
The data retention period for a database, schema, or table can be changed at any time. The same parameter can be used to explicitly override the default when creating a database, schema, and individual table. The DATA_RETENTION_TIME_IN_DAYS object parameter can be used by users with the ACCOUNTADMIN role to set the default To specify the data retention period for Time Travel: Past objects that were dropped can no longer be restored. Historical data is no longer available for querying. When the retention period ends for an object, the historical data is moved into Snowflake Fail-safe: The sameįor permanent databases, schemas, and tables, the retention period can be set to any value from 0 up to 90 days.Ī retention period of 0 days for an object effectively disables Time Travel for the object. databases, schemas, and tables).įor Snowflake Enterprise Edition (and higher):įor transient databases, schemas, and tables, the retention period can be set to 0 (or unset back to the default of 1 day). The standard retention period is 1 day (24 hours) and is automatically enabled for all Snowflake accounts:įor Snowflake Standard Edition, the retention period can be set to 0 (or unset back to the default of 1 day) at the account and object Time Travel operations (SELECT, CREATE … CLONE, UNDROP) can be performed on the data. The data retention period specifies the number of days for which this historical data is preserved and, therefore, When data in a table is modified, including deletion of data or dropping an object containing data, Snowflake preserves the state of the dataīefore the update. A key component of Snowflake Time Travel is the data retention period.
0 kommentar(er)
