ICEBERG TABLE

At this moment only UNMANAGED Iceberg tables are supported.

Please read a guide about using Iceberg tables with SnowDDL first.

Config path: /<database>/<schema>/iceberg_table/<name>.yaml

Examples:

metadata_file_path: test_iceberg_table_1/metadata/00001-cc112050-1448-4c2a-9e03-504e7f5fc62a.metadata.json
replace_invalid_characters: true

catalog_table_name: test_iceberg_table_1
comment: abc

Schema

• catalog_table_name (str) - name of Iceberg table in externally managed catalog

• catalog_namespace (str) - namespace of Iceberg table in externally managed catalog, inherited from CATALOG object by default

• metadata_file_path (str) - path to metadata file

• base_location (str) - path to base location of table files

• replace_invalid_characters (bool)

• auto_refresh (bool)

• comment (str)

Usage notes

1. EXTERNAL VOLUME name and CATALOG name should be specified in SCHEMA config.
2. It is required to specify one of the following parameters: catalog_table_name, metadata_file_path, base_location.

3. Unmanaged Iceberg tables are similar to Snowflake External tables. These tables are read-only and fully re-created in case of any changes in definition.

Links

• CREATE ICEBERG TABLE
• ALTER ICEBERG TABLE
• SHOW ICEBERG TABLES
• Parser & JSON Schema (GitHub)