Snowflake · Schema
EventTableColumn
DataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergModel Context ProtocolT1
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 |
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"
}
}
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/snowflake-eventtablecolumn"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.