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

iceberg-table-iceberg-table-as-select-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "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"
    },
    "columns": {
      "type": "array"
    },
    "external_volume": {
      "type": "string",
      "description": "Specifies the name of the external volume to use for the table"
    },
    "cluster_by": {
      "type": "array",
      "description": "Specifies one or more columns or column expressions in the table as the clustering key"
    },
    "base_location": {
      "type": "string",
      "description": "Specifies the path to a directory where Snowflake can write data and metadata files for the table"
    },
    "comment": {
      "type": "string",
      "description": "Specifies a comment for the table"
    }
  }
}