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

Snowflake dynamic-table API

The dynamic-table API from Snowflake — 10 operation(s) for dynamic-table.

Snowflake dynamic-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 dynamic-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 15 operations across 13 paths, and defines 6 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.

15 operations 13 paths 6 schemas 1 DELETE3 GET11 POST

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
Resource Areas
1

Authentication & Security 4

Snowflake dynamic-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 15

Across 13 paths, the API surfaces 15 operations — 1 DELETE, 3 GET, 11 POST. Each is listed below with its method, path, parameters, and response codes.

dynamic-table 15
GET
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables
List Dynamic Tables
listDynamicTables 7 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables
Create a Dynamic Table
createDynamicTable 3 params body → 200202400401403404405408
GET
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}
Fetch a Dynamic Table.
fetchDynamicTable 3 params → 200202400401403404405408
DELETE
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}
Delete a Dynamic Table
deleteDynamicTable 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:clone
Clone Dynamic Table
cloneDynamicTable 7 params body → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:undrop
Undrop a Dynamic Table
undropDynamicTable 3 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:suspend
Suspend Refreshes on the Dynamic Table
suspendDynamicTable 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:resume
Resume Refreshes on the Dynamic Table
resumeDynamicTable 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:refresh
Refresh the Dynamic Table
refreshDynamicTable 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:suspend-recluster
Suspend Recluster of a Dynamic Table
suspendReclusterDynamicTable 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:resume-recluster
Resume Recluster of a Dynamic Table
resumeReclusterDynamicTable 4 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:swap-with
Swap With Another Dynamic Table
swapWithDynamicTable 7 params → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:set-tags
Set tags on a dynamic table.
setTags 4 params body → 200202400401403404405408
POST
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:unset-tags
Unset tags from a dynamic table.
unsetTags 4 params body → 200202400401403404405408
GET
/api/v2/databases/{database}/schemas/{schema}/dynamic-tables/{name}:get-tags
Get the tag assignments for a dynamic table.
getTags 4 params → 200202400401403404405408

Schemas 6

The contract defines 6 schemas that model the data the API accepts and returns. The most detailed are DynamicTable_2 (23 properties), DynamicTable (22 properties), DynamicTableClone_2 (4 properties), DynamicTableClone (4 properties). Each schema is shown below with its type and property counts.

DynamicTableColumn
object
A column in the dynamic table
3 properties 1 required
DynamicTableClone
object
Clone dynamic table
4 properties 1 required
DynamicTable
object
A Snowflake dynamic table object.
22 properties 4 required
DynamicTableColumn_2
object
A column in the dynamic table
3 properties 1 required
DynamicTableClone_2
object
Clone dynamic table
4 properties 1 required
DynamicTable_2
object
A Snowflake dynamic table object.
23 properties 4 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

snowflake-dynamic-table-api-openapi.yml Raw ↑

Other APIs Snowflake publishes across the network.

Snowflake Artifact Repository API
Cortex Embed API
Snowflake Network Rule API
Snowflake Password Policy API
Snowflake Secret API
Snowflake Sequence API
Snowflake Spark Connect API
Snowflake Streamlit API
Snowflake Tag API
Cortex Agents API
Snowpipe REST API
Snowflake account API
Where this information came from

This is an independent, third-party profile of Snowflake dynamic-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.