STORAGE.DYNAMIC_TABLE_IMMUTABLE_WHERE

Target database: Snowflake

STORAGE.DYNAMIC_TABLE_IMMUTABLE_WHERE option enables:

Specification of condition that defines the immutable portion of the dynamic table.

See also:

DYNAMIC_TABLE

Usage

OPTION

STORAGE.DYNAMIC_TABLE_IMMUTABLE_WHERE: String

Default: empty

Notes

Supports only Snowflake Dynamic table

Examples

Snowflake: Set the STORAGE.DYNAMIC_TABLE_IMMUTABLE_WHERE

Setting STORAGE.DYNAMIC_TABLE_IMMUTABLE_WHERE for an Dynamic table (e.g. publish.F_TRIP):

OPTION

STORAGE.DYNAMIC_TABLE_IMMUTABLE_WHERE: timestamp_col < CURRENT_TIMESTAMP() - INTERVAL '1 day'

DDL generated by Agile Data Engine:

SQL

CREATE DYNAMIC TABLE publish.F_TRIP (
  timestamp_col TIMESTAMP,
  ...
)
..
IMMUTABLE WHERE (timestamp_col < CURRENT_TIMESTAMP() - INTERVAL '1 day')
...
AS
  SELECT timestamp_col, ...;