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:
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:
SQL
CREATE EXTERNAL TABLE publish.F_TRIP (
...
)
..
WITH LOCATION = @frequently_updated_data/trip
...;