How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Need help?

Contact us
Snowflake

Snowflake table API

The table API from Snowflake — 16 operation(s) for table.

Documentation Provider Profile APIs.io OpenAPI GitHub

Snowflake table API is one of 49 APIs that Snowflake publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 2 JSON Schema definitions.

Tagged areas include Table. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, a JSON-LD context, and 2 JSON Schemas.

This API exposes 22 operations across 19 paths, and defines 13 schemas. It is described by OpenAPI 3.2.0, at version 0.0.1.

Requests are made against a single base URL, https://org-account.snowflakecomputing.com.

22 operations 19 paths 13 schemas 1 DELETE3 GET17 POST1 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
0.0.1
Base URL
https://org-account.snowflakecomputing.com
Authentication
custom, custom, custom, custom
Contact
Snowflake, Inc.
Resource Areas
1

Authentication & Security 4

Snowflake table API declares 4 security schemes for authenticating requests. It defines a custom scheme (KeyPair). It defines a custom scheme (ExternalOAuth). It defines a custom scheme (SnowflakeOAuth). It defines a custom scheme (ProgrammaticAccessToken).

Paths & Operations 22

Across 19 paths, the API surfaces 22 operations — 1 DELETE, 3 GET, 17 POST, 1 PUT. Each is listed below with its method, path, parameters, and response codes.

table 22
GET
/api/v2/databases/{database}/schemas/{schema}/tables
List Tables
listTables 8 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables
Create a Table (clone and Undrop Are Separate Subresources)
createTable 4 params body → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:as_selectdeprecated
Create a Table Using the Result of the Specified Select Query
createTableAsSelectDeprecated 6 params body → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables:as-select
Create a Table Using the Result of the Specified Select Query
createTableAsSelect 5 params body → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:using_templatedeprecated
Create a Table Using the Templates Specified in Staged Files
createTableUsingTemplateDeprecated 6 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables:using-template
Create a Table Using the Templates Specified in Staged Files
createTableUsingTemplate 5 params body → 200202400401403404405408
GET
/api/v2/databases/{database}/schemas/{schema}/tables/{name}
Fetch a Table.
fetchTable 3 params → 200202400401403404405408
PUT
/api/v2/databases/{database}/schemas/{schema}/tables/{name}
Create a (or Alter an Existing) Table.
createOrAlterTable 3 params body → 200202400401403404405408
DELETE
/api/v2/databases/{database}/schemas/{schema}/tables/{name}
Delete a Table
deleteTable 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:clone
Clone Table
cloneTable 7 params body → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:create_likedeprecated
Create a Table Like This Existing One
createTableLikeDeprecated 6 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:create-like
Create a Table Like This Existing One
createTableLike 5 params body → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:undrop
Undrop a Table
undropTable 3 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:suspend_reclusterdeprecated
Suspend Recluster of a Table
suspendReclusterTableDeprecated 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:suspend-recluster
Suspend Recluster of a Table
suspendReclusterTable 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:resume_reclusterdeprecated
Resume Recluster of a Table
resumeReclusterTableDeprecated 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:resume-recluster
Resume Recluster of a Table
resumeReclusterTable 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:swapwithdeprecated
Swap With Another Table
swapWithTableDeprecated 5 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:swap-with
Swap With Another Table
swapWithTable 7 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:set-tags
Set tags on a table.
setTags 4 params body → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:unset-tags
Unset tags from a table.
unsetTags 4 params body → 200202400401403404405408
GET
/api/v2/databases/{database}/schemas/{schema}/tables/{name}:get-tags
Get the tag assignments for a table.
getTags 4 params → 200202400401403404405408

Schemas 13

The contract defines 13 schemas that model the data the API accepts and returns. The most detailed are Table (25 properties), Table_2 (25 properties), TableColumn (10 properties), TableColumn_2 (10 properties). Each schema is shown below with its type and property counts.

TableAsSelect
object
Create table as select
3 properties
Table
object
A Snowflake table
25 properties 1 required
TableUsingTemplate
object
Create table using template
1 property
Constraint
object
Constraints define integrity and consistency rules for data stored in tables.
3 properties
TableClone
object
Clone table
1 property
TableLike
object
Create table like an existing table
1 property
TableColumn
object
A column in the table
10 properties 2 required
TableAsSelect_2
object
Create table as select
3 properties
Table_2
object
A Snowflake table
25 properties 1 required
TableUsingTemplate_2
object
Create table using template
1 property
Constraint_2
object
Constraints define integrity and consistency rules for data stored in tables.
3 properties
TableLike_2
object
Create table like an existing table
1 property
TableColumn_2
object
A column in the table
10 properties 2 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

snowflake-table-api-openapi.yml Raw ↑

Other APIs Snowflake publishes across the network.

Snowflake Artifact Repository API
AE Profile APIs.io
Cortex Embed API
AE Profile APIs.io
Snowflake Network Rule API
AE Profile APIs.io
Snowflake Password Policy API
AE Profile APIs.io
Snowflake Secret API
AE Profile APIs.io
Snowflake Sequence API
AE Profile APIs.io
Snowflake Spark Connect API
AE Profile APIs.io
Snowflake Streamlit API
AE Profile APIs.io
Snowflake Tag API
AE Profile APIs.io
Cortex Agents API
AE Profile APIs.io
Snowpipe REST API
AE Profile APIs.io
Snowflake account API
AE Profile APIs.io
#Table
← Back to S APIs
API Details
ID
snowflake:snowflake-table-api
Base URL
https://org-account.snowflakecomputing.com
Docs
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference/account
Provider
Snowflake
APIs.io →  GitHub →
Explore more
All APIs Providers APIs.io Network
Work with this as data

Every API here is available over the API and to AI agents over MCP. APIs is not yet its own endpoint on the v1 API. Reach this content through network search and the tag graph, or the MCP server below.

Installs https://mcp.apievangelist.com/mcp in Claude, Cursor, VS Code and the rest — one button, every client.

MCP tools for apis
4 tools reach this content
  • search_api_evangelistSearch every content type across the network at once.
  • find_relatedThe shared-tag relevance graph — what else covers this.
  • get_tagEverything one tag labels, across all content types.
  • guide_topicPRO — a curated bundle for a topic: area, guidance, rules, papers, stories, services.
All tools & prompts
Call it yourself
curl for this page
Search the network for this 
curl "https://api.apievangelist.com/v1/search?q=snowflake-table-api&limit=10"
Everything under a tag 
curl "https://api.apievangelist.com/v1/tags/snowflake-table-api"

Discovery needs no key. Full bodies and the synthesis endpoints are Pro.

Get an API key

Free tier, no email required. Sign in with whichever identity you already have.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have. Your account

Where this information came from

This is an independent, third-party profile of Snowflake table API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.