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:
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:
SQL
CREATE DYNAMIC TABLE publish.F_TRIP (
...
)
..
REFRESH_MODE = INCREMENTAL
...
AS
SELECT ...;