STORAGE.ICEBERG_POINTER_FILE_NAME

Target database: Snowflake

STORAGE.ICEBERG_POINTER_FILE_NAME option enables:

Defining the file name for the pointer file activated with STORAGE.ICEBERG_POINTER_FILE_STAGE.

See also:

ICEBERG
STORAGE.ICEBERG_POINTER_FILE_STAGE

Usage

STORAGE.ICEBERG_POINTER_FILE_NAME: String

Default: empty

Notes

Supports only Snowflake Iceberg table.

Examples

Snowflake: Enable the STORAGE.ICEBERG_POINTER_FILE_NAME

Setting STORAGE.ICEBERG_POINTER_FILE_NAME to data_file for an Iceberg table (e.g. publish.F_TRIP):

STORAGE.ICEBERG_POINTER_FILE_NAME: data_file
STORAGE.ICEBERG_POINTER_FILE_STAGE:snowflake_external_stage

DDL generated by Agile Data Engine:

SQL

COPY INTO @snowflake_external_stage/data_file
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;