Snowflake · Schema

IcebergTableAsSelect

Create iceberg table as select

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name	Type	Description
name	string	Specifies the name for the table, must be unique for the schema in which the table is created
columns	array
external_volume	string	Specifies the name of the external volume to use for the table
cluster_by	array	Specifies one or more columns or column expressions in the table as the clustering key
base_location	string	Specifies the path to a directory where Snowflake can write data and metadata files for the table
comment	string	Specifies a comment for the table

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/IcebergTableAsSelect",
  "title": "IcebergTableAsSelect",
  "type": "object",
  "description": "Create iceberg table as select",
  "properties": {
    "name": {
      "type": "string",
      "description": "Specifies the name for the table, must be unique for the schema in which the table is created",
      "example": "Example Title"
    },
    "columns": {
      "type": "array",
      "items": {
        "$ref": "#/components/schemas/IcebergTableColumn"
      },
      "example": []
    },
    "external_volume": {
      "type": "string",
      "description": "Specifies the name of the external volume to use for the table",
      "example": "example_value"
    },
    "cluster_by": {
      "type": "array",
      "description": "Specifies one or more columns or column expressions in the table as the clustering key",
      "items": {
        "type": "string"
      },
      "example": []
    },
    "base_location": {
      "type": "string",
      "description": "Specifies the path to a directory where Snowflake can write data and metadata files for the table",
      "example": "example_value"
    },
    "comment": {
      "type": "string",
      "description": "Specifies a comment for the table",
      "example": "example_value"
    }
  },
  "required": [
    "name",
    "base_location"
  ]
}