Target database: Snowflake
STORAGE.EXTERNAL_TABLE_REFRESH_ON_CREATE option defines whether the external table is immediately refreshed at the time of creation or not.
See also:
Usage
STORAGE.EXTERNAL_TABLE_REFRESH_ON_CREATE: boolean
Default: true
Notes
Valid only with Snowflake External Table.
Examples
Snowflake: Set the STORAGE.EXTERNAL_TABLE_REFRESH_ON_CREATE
Setting STORAGE.EXTERNAL_TABLE_REFRESH_ON_CREATE for an External table (e.g. publish.F_TRIP):
STORAGE.EXTERNAL_TABLE_REFRESH_ON_CREATE: false
DDL generated by Agile Data Engine:
CREATE EXTERNAL TABLE publish.F_TRIP (
...
)
..
REFRESH_ON_CREATE = FALSE;
...;