STORAGE.ICEBERG_MERGE_ON_READ_BEHAVIOR

STORAGE.ICEBERG_MERGE_ON_READ_BEHAVIOR option defines:

Whether iceberg merge on red behavior is one of:

• AUTO

• DISABLED

• ENABLED

See also:

• ICEBERG

• https://docs.snowflake.com/en/sql-reference/sql/create-iceberg-table#snowflake-as-the-iceberg-catalog

Usage

STORAGE.ICEBERG_MERGE_ON_READ_BEHAVIOR: String

Default: empty

Notes

Supports only Snowflake Iceberg table.

Examples

Snowflake: Enable the STORAGE.ICEBERG_MERGE_ON_READ_BEHAVIOR

Setting STORAGE.ICEBERG_MERGE_ON_READ_BEHAVIOR to DISABLED for an Iceberg table (e.g. publish.F_TRIP):

STORAGE.ICEBERG_TARGET_FILE_SIZE: DISABLED

DDL generated by Agile Data Engine:

CREATE ICEBERG TABLE publish.F_TRIP (
    ...
)
...
ICEBERG_MERGE_ON_READ_BEHAVIOR = 'DISABLED'
...
;