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