STORAGE.ICEBERG_SERIALIZATION_POLICY

Target database: Snowflake

STORAGE.ICEBERG_SERIALIZATION_POLICY option enables:

Enables defining the serialization policy for the Iceberg table.

See also:

ICEBERG

Usage

OPTION

STORAGE.ICEBERG_SERIALIZATION_POLICY: String

Default: empty

Supported values:

COMPATIBLE
OPTIMIZED (if nothing defined, this is Snowflake default)

Notes

Supports only Snowflake Iceberg table.

Examples

Snowflake: Enable the STORAGE.ICEBERG_SERIALIZATION_POLICY

Setting STORAGE.ICEBERG_SERIALIZATION_POLICY to COMPATIBLE for an Iceberg table (e.g. publish.F_TRIP):

OPTION

STORAGE.ICEBERG_SERIALIZATION_POLICY: COMPATIBLE

DDL generated by Agile Data Engine:

SQL

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