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

PreviousHYBRID TABLENextMASKING POLICY

Last updated