STORAGE.CHANGE_TRACKING

Target database: Snowflake

STORAGE.CHANGE_TRACKING physical option enables Snowflake change tracking for a table. Change tracking allows querying table changes within a given time window.

See also:

• Changes (Snowflake documentation)

• Change tracking using streams (Snowflake documentation)

• CONFIG_ENTITY_DEFAULTS

Usage

STORAGE.CHANGE_TRACKING: Boolean

Default: false

Notes

Change tracking can be enabled for tables.

When change tracking is enabled, ADE prevents entity recreation during deployment to protect the change history:

CHANGE CASE: ENTITY_RECREATION_PREVENTED_BY_CHANGE_TRACKING

To deploy changes requiring entity recreation, disable change tracking first.

Examples

Enabling change tracking for a table

Set STORAGE.CHANGE_TRACKING to true for a table (e.g. F_TRIP):

STORAGE.CHANGE_TRACKING: true

DDL generated by Agile Data Engine:

ALTER TABLE publish.F_TRIP SET CHANGE_TRACKING = true;