REFRESH.DYNAMIC_TABLE_TARGET_LAG

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:

• DYNAMIC_TABLE

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:

CREATE DYNAMIC TABLE publish.F_TRIP (
  ...
)
..
TARGET_LAG = '4 minutes'
...
AS
  SELECT ...;