![]() 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 is also trueį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. 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 level (i.e.į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). 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, Time Travel 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 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |