STORAGE.ICEBERG_EXTERNAL_LOCATION

Target database: Snowflake

STORAGE.ICEBERG_EXTERNAL_LOCATION option enables:

Points the Iceberg table to be created to a desired external volume

See also:

• ICEBERG

Usage

STORAGE.ICEBERG_EXTERNAL_LOCATION: String

Default: empty

Notes

Supports only Snowflake Iceberg table and requires the external volume to be available.

Examples

Snowflake: Enable the STORAGE.ICEBERG_EXTERNAL_LOCATION

Setting STORAGE.ICEBERG_EXTERNAL_LOCATION to snowflake_external_volume for an Iceberg table (e.g. publish.F_TRIP):

STORAGE.ICEBERG_EXTERNAL_LOCATION: snowflake_external_volume

DDL generated by Agile Data Engine:

CREATE ICEBERG TABLE publish.F_TRIP (
    ...
)
EXTERNAL_VOLUME = 'snowflake_external_volume'
CATALOG ='SNOWFLAKE'
BASE_LOCATION ='publish_f_trip';