STORAGE.EXTERNAL_TABLE_LOCATION

Target database: Snowflake

STORAGE.EXTERNAL_TABLE_LOCATION option specifies the external stage and optional path where the files containing data to be read are staged.

See also:

• EXTERNAL_TABLE

Usage

STORAGE.EXTERNAL_TABLE_LOCATION: String

Default: Empty.

Syntax: String of format @[namespace.]ext_stage_name[/path]

Notes

Supports only Snowflake External table

Examples

Snowflake: Set the STORAGE.EXTERNAL_TABLE_LOCATION

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

STORAGE.EXTERNAL_TABLE_LOCATION: @frequently_updated_data/trip

DDL generated by Agile Data Engine:

CREATE EXTERNAL TABLE publish.F_TRIP (
  ...
)
..
WITH LOCATION = @frequently_updated_data/trip
...;