Snowflake · JSON Structure

Iceberg Table Iceberg Table Structure

Type: object Properties: 25
Data LakesData SharingData WarehousingDatabaseSQL

IcebergTable is a JSON Structure definition published by Snowflake, describing 25 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

name comment change_tracking max_data_extension_time_in_days external_volume data_retention_time_in_days catalog_sync catalog storage_serialization_policy created_on database_name schema_name owner owner_role_type iceberg_table_type catalog_table_name catalog_namespace can_write_metadata cluster_by columns base_location replace_invalid_characters auto_refresh metadata_file_path constraints

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "IcebergTable",
  "type": "object",
  "properties": {
    "name": {
      "type": "string"
    },
    "comment": {
      "type": "string"
    },
    "change_tracking": {
      "type": "boolean"
    },
    "max_data_extension_time_in_days": {
      "type": "integer"
    },
    "external_volume": {
      "type": "string"
    },
    "data_retention_time_in_days": {
      "type": "integer"
    },
    "catalog_sync": {
      "type": "string"
    },
    "catalog": {
      "type": "string"
    },
    "storage_serialization_policy": {
      "type": "string"
    },
    "created_on": {
      "type": "string"
    },
    "database_name": {
      "type": "string"
    },
    "schema_name": {
      "type": "string"
    },
    "owner": {
      "type": "string"
    },
    "owner_role_type": {
      "type": "string"
    },
    "iceberg_table_type": {
      "type": "string"
    },
    "catalog_table_name": {
      "type": "string"
    },
    "catalog_namespace": {
      "type": "string"
    },
    "can_write_metadata": {
      "type": "string"
    },
    "cluster_by": {
      "type": "array"
    },
    "columns": {
      "type": "array"
    },
    "base_location": {
      "type": "string"
    },
    "replace_invalid_characters": {
      "type": "boolean"
    },
    "auto_refresh": {
      "type": "boolean"
    },
    "metadata_file_path": {
      "type": "string"
    },
    "constraints": {
      "type": "array"
    }
  }
}