Snowflake · JSON Structure

Snowflake Sql Rest Column Definition Structure

Type: object Properties: 6
Data LakesData SharingData WarehousingDatabaseSQL

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

Properties

name type length precision scale nullable

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

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "ColumnDefinition",
  "type": "object",
  "properties": {
    "name": {
      "type": "string"
    },
    "type": {
      "type": "string"
    },
    "length": {
      "type": "integer"
    },
    "precision": {
      "type": "integer"
    },
    "scale": {
      "type": "integer"
    },
    "nullable": {
      "type": "boolean"
    }
  }
}