Snowflake · Schema

EventTableColumn

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name	Type	Description
name	string	Column name
datatype	string	The data type for the column
nullable	boolean	Specifies that the column does allow NULL values or not
default	string	Specifies whether a default value is automatically inserted in the column if a value is not explicitly specified via an INSERT or CREATE TABLE AS SELECT statement
primary_key	boolean	A primary key is the column or columns that contain values that uniquely identify each row in a table
unique_key	boolean	Unique keys are columns in a table that uniquely identify items in the rows. This sounds a lot like a primary key, but the main difference is that unique keys can have NULL values.
check	string
expression	string
comment	string	Specifies a comment for the column

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/EventTableColumn",
  "title": "EventTableColumn",
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "description": "Column name",
      "example": "Example Title"
    },
    "datatype": {
      "type": "string",
      "description": "The data type for the column",
      "example": "example_value"
    },
    "nullable": {
      "type": "boolean",
      "description": "Specifies that the column does allow NULL values or not",
      "example": true
    },
    "default": {
      "type": "string",
      "description": "Specifies whether a default value is automatically inserted in the column if a value is not explicitly specified via an INSERT or CREATE TABLE AS SELECT statement",
      "example": "example_value"
    },
    "primary_key": {
      "type": "boolean",
      "description": "A primary key is the column or columns that contain values that uniquely identify each row in a table",
      "example": true
    },
    "unique_key": {
      "type": "boolean",
      "description": "Unique keys are columns in a table that uniquely identify items in the rows. This sounds a lot like a primary key, but the main difference is that unique keys can have NULL values.",
      "example": true
    },
    "check": {
      "type": "string",
      "description": "",
      "example": "example_value"
    },
    "expression": {
      "type": "string",
      "description": "",
      "example": "example_value"
    },
    "comment": {
      "type": "string",
      "description": "Specifies a comment for the column",
      "example": "example_value"
    }
  }
}