REFRESH.DYNAMIC_TABLE_REFRESH_MODE

Target database: Snowflake

REFRESH.DYNAMIC_TABLE_REFRESH_MODE option enables:

Definition of the wanted dynamic target refresh mode. Based on Snowflake documentation the options are:

• AUTO

• FULL

• INCREMENTAL

See also:

• DYNAMIC_TABLE

Usage

REFRESH.DYNAMIC_TABLE_REFRESH_MODE: String

Default: empty, Snowflake will interpret this as AUTO.

Notes

Supports only Snowflake Dynamic table

Examples

Snowflake: Set the REFRESH.DYNAMIC_TABLE_REFRESH_MODE

Setting REFRESH.DYNAMIC_TABLE_REFRESH_MODE for an Dynamic table (e.g. publish.F_TRIP):

REFRESH.DYNAMIC_TABLE_REFRESH_MODE: INCREMENTAL

DDL generated by Agile Data Engine:

CREATE DYNAMIC TABLE publish.F_TRIP (
  ...
)
..
REFRESH_MODE = INCREMENTAL
...
AS
  SELECT ...;