Skip to main content
Skip table of contents

STORAGE.TIME_TRAVEL_RETENTION_IN_DAYS

Target database: Snowflake

STORAGE.TIME_TRAVEL_RETENTION_IN_DAYS option creates or modifies entity to have Snowflake time travel retention table option on or off.


See also:


Usage

OPTION
STORAGE.TIME_TRAVEL_RETENTION_IN_DAYS: integer

Notes

Time travel retention can be configured with STORAGE.TIME_TRAVEL_RETENTION_IN_DAYS for tables.

Time travel retention can be set in Snowflake on multiple levels such as account level and schema level, objects can inherit higher-level settings. Please refer to the Snowflake documentation.

For transient tables time travel retention period can be set to 0 or 1 days.

More than 1 day time travel retention requires Snowflake Enterprise Edition or higher.


Examples

Setting time travel retention for an entity

Option value set to 30 days:

OPTION
STORAGE.TIME_TRAVEL_RETENTION_IN_DAYS: 30

DDL executed in Snowflake:

SQL
CREATE TABLE ...
DATA_RETENTION_TIME_IN_DAYS = 30;
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.