ICEBERG_TABLE

Supported DBMS products: Snowflake

Limitations:

• Catalog needs to be Snowflake managed

• ADE Logical datatypes not supported:

  • ARRAY

  • GEOGRAPHY

  • GEOMETRY

  • OBJECT

  • TIMESTAMP_TZ

  • TIMESTAMP_WITH_SCALE

  • VARIANT

Physical options related to ICEBERG_TABLE

• STORAGE.ICEBERG_POINTER_FILE_STAGE

• STORAGE.ICEBERG_EXTERNAL_LOCATION

• STORAGE.ICEBERG_SERIALIZATION_POLICY

• STORAGE.TIME_TRAVEL_RETENTION_TIME_IN_DAYS

• STORAGE.AUTO_CLUSTERING_SUSPEND

• STORAGE.SEARCH_OPTIMIZATION

• STORAGE.SEARCH_OPTIMIZATION_OPTIONS

• STORAGE.CHANGE_TRACKING

Good to know

Iceberg table in Snowflake requires the EXTERNAL_VOLUME to be either defined as default in Snowflake on database or schema level or it needs to be set by using STORAGE.ICEBERG_EXTERNAL_LOCATION physical option.

Only Snowflake is supported Catalog option and therefore it can not be modified at the moment.

Base location for the Iceberg table will be of format

<entity_schema>_<entity_name>.<random_sequence>

The Iceberg table serialization policy will default to OPTIMIZED, but as it might not be suitable for external readers, it might be better to set STORAGE.ICEBERG_SERIALIZATION_POLICY physical option as COMPATIBLE.

Clustering can be enabled by adding a SORT_KEY for the ICEBERG_TABLE physical type.

Time travel, search optimization and change tracking are supported also for ICEBERG_TABLE.

See also

• https://docs.snowflake.com/en/sql-reference/sql/create-iceberg-table-snowflake