REFRESH.DYNAMIC_TABLE_WAREHOUSE

Target database: Snowflake

• REFRESH.DYNAMIC_TABLE_WAREHOUSE option enables:

Definition of the wanted warehouse for the dynamic table to execute the table updation according to the wanted time constraints.

See also:

• DYNAMIC_TABLE

• REFRESH.DYNAMIC_TABLE_TARGET_LAG

Usage

REFRESH.DYNAMIC_TABLE_WAREHOUSE: String

Default: empty

NOTE! Dynamic table requires the warehouse to be defined.

Notes

Supports only Snowflake Dynamic table

Examples

Snowflake: Set the REFRESH.DYNAMIC_TABLE_WAREHOUSE

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

REFRESH.DYNAMIC_TABLE_WAREHOUSE: my_example_wh

DDL generated by Agile Data Engine:

CREATE DYNAMIC TABLE publish.F_TRIP (
  ...
)
..
WAREHOUSE = my_example_wh
...
AS
  SELECT ...;