STORAGE.ICEBERG_POINTER_FILE_STAGE

Target database: Snowflake

STORAGE.ICEBERG_POINTER_FILE_STAGE option enables:

Writing the latest physical storage location prefix for the specified Iceberg table in to <schemaSchema>.<entityName> - file to the external stage specified in this physical option.

See also:

ICEBERG

Usage

OPTION

STORAGE.ICEBERG_POINTER_FILE_STAGE: String

Default: empty

Notes

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

Examples

Snowflake: Enable the STORAGE.ICEBERG_POINTER_FILE_STAGE

Setting STORAGE.ICEBERG_POINTER_FILE_STAGE to snowflake_external_stage for an Iceberg table (e.g. publish.F_TRIP):

OPTION

STORAGE.ICEBERG_POINTER_FILE_STAGE: snowflake_external_stage

DDL generated by Agile Data Engine:

SQL

COPY INTO @snowflake_external_stage/publish.F_TRIP
FROM (
   SELECT REGEXP_REPLACE(SPLIT_PART(CAST(value AS STRING),'metadata',1),'/$','') AS metadataLocation FROM TABLE(FLATTEN(PARSE_JSON(SYSTEM$GET_ICEBERG_TABLE_INFORMATION('PUBLISH.F_TRIP')))) f
   WHERE key = 'metadataLocation'
)
FILE_FORMAT = (TYPE='csv' COMPRESSION = 'none')
SINGLE = true
OVERWRITE = true;