Snowflake · Schema
IcebergTable
A Snowflake iceberg table
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| name | string | Name of the iceberg table |
| comment | string | user comment associated to an object in the dictionary |
| change_tracking | boolean | True if change tracking is enabled, allowing streams and CHANGES to be used on the entity. |
| max_data_extension_time_in_days | integer | Maximum number of days to extend data retention beyond the retention period to prevent a stream becoming stale. |
| external_volume | string | Name of an external volume that will be used for persisted Iceberg metadata and data files. |
| data_retention_time_in_days | integer | number of days to retain the old version of deleted/updated data |
| catalog_sync | string | Name of the catalog integration to sync this table |
| catalog | string | Name of the catalog integration to use for iceberg tables |
| storage_serialization_policy | string | Storage serialization policy used for managed Iceberg table. This include encodings and compressions |
| created_on | string | Date and time when the iceberg table was created. |
| database_name | string | Database in which the iceberg table is stored |
| schema_name | string | Schema in which the iceberg table is stored |
| owner | string | Role that owns the iceberg table |
| owner_role_type | string | The type of role that owns the iceberg table |
| iceberg_table_type | string | Type of Iceberg table. UNMANAGED if the table is not managed by Snowflake. NOT ICEBERG otherwise. |
| catalog_table_name | string | Name of the table as recognized by the catalog. |
| catalog_namespace | string | Catalog namespace for the table. The namespace defined when the table was created. Otherwise, the default namespace associated with the catalog integration used by the table. If you’re syncing the tab |
| can_write_metadata | string | Signifies whether Snowflake can write metadata to the location specified by the file_path. |
| cluster_by | array | Specifies one or more columns or column expressions in the table as the clustering key. |
| columns | array | |
| base_location | string | The path to a directory where Snowflake can write data and metadata files for the table. |
| replace_invalid_characters | boolean | Specifies whether to replace invalid characters in the column names |
| auto_refresh | boolean | Specifies whether to automatically refresh the table metadata |
| metadata_file_path | string | Specifies the relative path of the Iceberg metadata file to use for column definitions. |
| constraints | array |