STORAGE.EXTERNAL_TABLE_INTEGRATION

Target database: Snowflake

STORAGE.EXTERNAL_TABLE_INTEGRATION option specifies the name of the notification integration used to automatically refresh the external table metadata notifications. A notification integration is a Snowflake object that provides an interface between Snowflake and third-party cloud message queuing services.

This parameter is required to enable auto-refresh operations for the external table in Azure Blob Storage or Google Cloud Storage.

See also:

EXTERNAL_TABLE

Usage

OPTION

STORAGE.EXTERNAL_TABLE_INTEGRATION: String

Default: Empty.

Notes

Supports only Snowflake External table

Examples

Snowflake: Set the STORAGE.EXTERNAL_TABLE_INTEGRATION

Setting STORAGE.EXTERNAL_TABLE_INTEGRATION for an External table (e.g. publish.F_TRIP):

OPTION

STORAGE.EXTERNAL_TABLE_INTEGRATION: azure_blob_refresher

DDL generated by Agile Data Engine:

SQL

CREATE EXTERNAL TABLE publish.F_TRIP (
  ...
)
..
INTEGRATION = azure_blob_refresher
...;