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:

• Understanding & Using Time Travel (Snowflake documentation)

• STORAGE.TRANSIENT_TABLE

• CONFIG_ENTITY_DEFAULTS

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;