STORAGE.TRANSIENT_TABLE

Target database: Snowflake

STORAGE.TRANSIENT_TABLE toggles the Snowflake transient table option for an entity.

Option toggles off use Fail-safe and Time Travel areas in Snowflake. STORAGE.TRANSIENT_TABLE -option is ideal for tables which are constantly truncated and reloaded as it reduces costs generated by Snowflake Fail-safe and Time Travel -features.

See also:

• Working with Temporary and Transient Tables (Snowflake documentation)

• STORAGE.TIME_TRAVEL_RETENTION_IN_DAYS

• CONFIG_ENTITY_DEFAULTS

Usage

STORAGE.TRANSIENT_TABLE: Boolean

Default: false

Notes

STORAGE.TRANSIENT_TABLE can be used with tables.

STORAGE.TRANSIENT_TABLE affects Snowflake fail-safe and time travel features, please refer to the Snowflake documentation.

Tables that are constantly truncated and reloaded, such as staging tables and truncate-insert style publish tables, are ideal candidates for the transient option as it reduces costs generated by the fail-safe and time travel features in Snowflake.

Examples

Enabling transient table option for an entity

Option value set to true:

STORAGE.TRANSIENT_TABLE: true

DDL executed in Snowflake:

CREATE TRANSIENT TABLE ... ;