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
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:
STORAGE.TIME_TRAVEL_RETENTION_IN_DAYS: 30
DDL executed in Snowflake:
CREATE TABLE ...
DATA_RETENTION_TIME_IN_DAYS = 30;