STORAGE.EXTERNAL_TABLE_LOCATION

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:

SNOWFLAKE:

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

DATABRICKS:

Cloud provider cloud storage uri, e.g. s3://data_location/ext_stage_name[/path]

Notes

Supports Snowflake and Databricks SQL 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
...;

Databricks SQL: Set the STORAGE.EXTERNAL_TABLE_LOCATION

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

STORAGE.EXTERNAL_TABLE_LOCATION: s3://data_location/ext_stage_name

DDL generated by Agile Data Engine:

CREATE TABLE publish.F_TRIP (
  ...
)
..
LOCATION = 's3://data_location/ext_stage_name'
...;