CREATE DYNAMIC ICEBERG TABLE command: Write data types to table files¶

With this release, the CREATE DYNAMIC ICEBERG TABLE command behaves as follows:

Before the change:

Snowflake-managed dynamic Apache Iceberg™ tables created with explicit column definitions do not write iceberg data types to table files.

After the change:

Snowflake-managed dynamic Apache Iceberg™ tables created with explicit column definitions write iceberg data types to table files.

The following is an example of a Snowflake-managed dynamic Apache Iceberg™ table with explicit column definitions:

CopyExpand

CREATE OR REPLACE DYNAMIC ICEBERG TABLE iceberg_dt (id int)
  WAREHOUSE = mywh
  TARGET_LAG = 'downstream'
  EXTERNAL_VOLUME = 'iceberg_default_volume'
  BASE_LOCATION = 'my_base_location'
  CATALOG = 'snowflake'
  AS
    SELECT id FROM base_table;

Show lessSee more

Scroll to top

Ref: 1773