STORAGE.DYNAMIC_TABLE_INITIALIZE_BEHAVIOR

Target database: Snowflake

STORAGE.DYNAMIC_TABLE_INITIALIZE_BEHAVIOR option enables:

Definition of the wanted dynamic table initialization behavior. Based on Snowflake documentation the options are:

• ON_CREATE

• ON_SCHEDULE

See also:

• DYNAMIC_TABLE

Usage

STORAGE.DYNAMIC_TABLE_INITIALIZE_BEHAVIOR: String

Default: empty, Snowflake will interpret this as ON_CREATE.

Notes

Supports only Snowflake Dynamic table

Examples

Snowflake: Set the STORAGE.DYNAMIC_TABLE_INITIALIZE_BEHAVIOR

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

STORAGE.DYNAMIC_TABLE_INITIALIZE_BEHAVIOR: ON_SCHEDULE

DDL generated by Agile Data Engine:

CREATE DYNAMIC TABLE publish.F_TRIP (
  ...
)
..
INITIALIZE = ON_SCHEDULE
...
AS
  SELECT ...;