Snowflake · Schema

ColumnDefinition

Describes a column in the result set.

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
name string Name of the column.
type string Snowflake data type of the column (e.g. FIXED, TEXT, BOOLEAN, DATE, TIMESTAMP_NTZ, VARIANT, ARRAY, OBJECT).
length integer Maximum length of the column data.
precision integer Precision of numeric data.
scale integer Scale of numeric data.
nullable boolean Whether the column allows null values.
View JSON Schema on GitHub

JSON Schema

snowflake-sql-rest-column-definition-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "ColumnDefinition",
  "type": "object",
  "description": "Describes a column in the result set.",
  "properties": {
    "name": {
      "type": "string",
      "description": "Name of the column."
    },
    "type": {
      "type": "string",
      "description": "Snowflake data type of the column (e.g. FIXED, TEXT, BOOLEAN, DATE, TIMESTAMP_NTZ, VARIANT, ARRAY, OBJECT)."
    },
    "length": {
      "type": "integer",
      "description": "Maximum length of the column data."
    },
    "precision": {
      "type": "integer",
      "description": "Precision of numeric data."
    },
    "scale": {
      "type": "integer",
      "description": "Scale of numeric data."
    },
    "nullable": {
      "type": "boolean",
      "description": "Whether the column allows null values."
    }
  }
}