REFRESH.EXTERNAL_TABLE_AUTO_REFRESH

Target database: Snowflake

REFRESH.EXTERNAL_TABLE_AUTO_REFRESH option enables:

Setting whether the external table should be either manually or automatically refreshed. By default this is set false, which means manual table refreshing.

See also:

EXTERNAL_TABLE

Usage

OPTION

REFRESH.EXTERNAL_TABLE_AUTO_REFRESH: Boolean

Default: true

Notes

Supports only Snowflake External table

Examples

Snowflake: Set the REFRESH.EXTERNAL_TABLE_AUTO_REFRESH as true

Setting REFRESH.EXTERNAL_TABLE_AUTO_REFRESH for an External table (e.g. publish.F_TRIP):

OPTION

REFRESH.EXTERNAL_TABLE_AUTO_REFRESH: false

DDL generated by Agile Data Engine:

SQL

CREATE EXTERNAL TABLE publish.F_TRIP (
  ...
)
..
AUTO_REFRESH = FALSE
...;