STORAGE.EXTERNAL_TABLE_REFRESH_ON_CREATE

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:

• EXTERNAL_TABLE

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;
...;​