Snowflake · Schema

ColumnType

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
name string Argument name
datatype string Argument data type
View JSON Schema on GitHub

JSON Schema

snowflake-columntype-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/ColumnType",
  "title": "ColumnType",
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "pattern": "^\"([^\"]|\"\")+\"|[a-zA-Z_][a-zA-Z0-9_$]*$",
      "description": "Argument name",
      "example": "Example Title"
    },
    "datatype": {
      "type": "string",
      "enum": [
        "ARRAY",
        "BIGINT",
        "BINARY",
        "BOOLEAN",
        "BYTEINT",
        "CHAR",
        "CHARACTER",
        "DATE",
        "DATETIME",
        "DECIMAL",
        "DOUBLE",
        "DOUBLE PRECISION",
        "FLOAT",
        "FLOAT4",
        "FLOAT8",
        "GEOGRAPHY",
        "GEOMETRY",
        "INT",
        "INTEGER",
        "NUMBER",
        "NUMERIC",
        "OBJECT",
        "REAL",
        "STRING",
        "SMALLINT",
        "TEXT",
        "TIME",
        "TIMESTAMP_LTZ",
        "TIMESTAMP_NTZ",
        "TIMESTAMP_TZ",
        "TINYINT",
        "VARBINARY",
        "VARCHAR",
        "VARIANT",
        "VECTOR"
      ],
      "x-enum-varnames": [
        "ARRAY",
        "BIGINT",
        "BINARY",
        "BOOLEAN",
        "BYTEINT",
        "CHAR",
        "CHARACTER",
        "DATE",
        "DATETIME",
        "DECIMAL",
        "DOUBLE",
        "DOUBLE_PRECISION",
        "FLOAT",
        "FLOAT4",
        "FLOAT8",
        "GEOGRAPHY",
        "GEOMETRY",
        "INT",
        "INTEGER",
        "NUMBER",
        "NUMERIC",
        "OBJECT",
        "REAL",
        "STRING",
        "SMALLINT",
        "TEXT",
        "TIME",
        "TIMESTAMP_LTZ",
        "TIMESTAMP_NTZ",
        "TIMESTAMP_TZ",
        "TINYINT",
        "VARBINARY",
        "VARCHAR",
        "VARIANT",
        "VECTOR"
      ],
      "description": "Argument data type",
      "example": "ARRAY"
    }
  },
  "required": [
    "name",
    "datatype"
  ]
}