Target database: Snowflake
REFRESH.DYNAMIC_TABLE_TARGET_LAG option enables:
Definition of the wanted dynamic target table lag compared to the data sources involved in the dynamic table query.
See also:
Usage
REFRESH.DYNAMIC_TABLE_TARGET_LAG: String
Default: empty
NOTE! Dynamic table requires the target lag to be defined.
Notes
Supports only Snowflake Dynamic table
Examples
Snowflake: Set the REFRESH.DYNAMIC_TABLE_TARGET_LAG
Setting REFRESH.DYNAMIC_TABLE_TARGET_LAG for an Dynamic table (e.g. publish.F_TRIP):
REFRESH.DYNAMIC_TABLE_TARGET_LAG: 4 minutes
DDL generated by Agile Data Engine:
SQL
CREATE DYNAMIC TABLE publish.F_TRIP (
...
)
..
TARGET_LAG = '4 minutes'
...
AS
SELECT ...;