Snowflake · OpenAPI Overlay 1.0.0
API Evangelist enhancements for Snowflake Table API
4 actions
4 updates
update
extends
openapi/snowflake-table-api-openapi.yml
Derived by API Evangelist
Built from the contracts Snowflake publishes. Snowflake did not publish this file.
What the actions change
x-artifactsx-providerx-runtime-semanticsx-deprecated-operationsx-rate-limit-gap
Targets 2
$.info
$
OpenAPI Overlay
overlay: 1.0.0
info:
title: API Evangelist enhancements for Snowflake Table API
version: 1.0.0
extends: openapi/snowflake-table-api-openapi.yml
x-generated: '2026-09-03'
x-method: generated
x-source: 'Generated from openapi/snowflake-table-api-openapi.yml (22 operations, tags: table). Captures API Evangelist derivations only; the
underlying OpenAPI is not mutated.'
actions:
- target: $.info
description: Cross-link the API Evangelist artifact set derived from this contract.
update:
x-artifacts:
errors: ../errors/snowflake-problem-types.yml
conventions: ../conventions/snowflake-conventions.yml
lifecycle: ../lifecycle/snowflake-lifecycle.yml
authentication: ../authentication/snowflake-authentication.yml
scopes: ../scopes/snowflake-scopes.yml
rate-limits: ../rate-limits/snowflake-rate-limits.yml
conformance: ../conformance/snowflake-conformance.yml
data-model: ../data-model/snowflake-data-model.yml
packages: ../packages/snowflake-packages.yml
mcp: ../mcp/snowflake-mcp.yml
skills: ../skills/_index.yml
x-provider: snowflake
- target: $
description: Record the runtime semantics that are shared across every Snowflake REST contract but stated in none of them.
update:
x-runtime-semantics:
error-envelope: application/json { message, code, error_code (deprecated), request_id } — not RFC 9457
request-id-header: X-Snowflake-Request-ID (uuid) on every response
pagination: showLimit / fromName query parameters plus an RFC 8288 Link header; the body is a bare array with no paging envelope
idempotency: declarative via createMode (errorIfExists|ifNotExists|orReplace) and ifExists — there is no Idempotency-Key header
auth-type-header: X-Snowflake-Authorization-Token-Type must accompany Authorization and name the credential kind
rate-limit-signalling: 429 with no Retry-After and no RateLimit-* headers; client-side jittered backoff from ~2s
dry-run: not supported anywhere in the Snowflake REST API
- target: $.info
description: Flag the deprecated operations in this document; the contract marks them deprecated but publishes no sunset date and no replacement
pointer.
update:
x-deprecated-operations:
- operationId: createTableAsSelectDeprecated
path: /api/v2/databases/{database}/schemas/{schema}/tables/{name}:as_select
method: post
sunset: null
note: 'deprecated: true in the contract; no Sunset/Deprecation header is emitted at runtime and no sunset date is published.'
- operationId: createTableUsingTemplateDeprecated
path: /api/v2/databases/{database}/schemas/{schema}/tables/{name}:using_template
method: post
sunset: null
note: 'deprecated: true in the contract; no Sunset/Deprecation header is emitted at runtime and no sunset date is published.'
- operationId: createTableLikeDeprecated
path: /api/v2/databases/{database}/schemas/{schema}/tables/{name}:create_like
method: post
sunset: null
note: 'deprecated: true in the contract; no Sunset/Deprecation header is emitted at runtime and no sunset date is published.'
- operationId: suspendReclusterTableDeprecated
path: /api/v2/databases/{database}/schemas/{schema}/tables/{name}:suspend_recluster
method: post
sunset: null
note: 'deprecated: true in the contract; no Sunset/Deprecation header is emitted at runtime and no sunset date is published.'
- operationId: resumeReclusterTableDeprecated
path: /api/v2/databases/{database}/schemas/{schema}/tables/{name}:resume_recluster
method: post
sunset: null
note: 'deprecated: true in the contract; no Sunset/Deprecation header is emitted at runtime and no sunset date is published.'
- operationId: swapWithTableDeprecated
path: /api/v2/databases/{database}/schemas/{schema}/tables/{name}:swapwith
method: post
sunset: null
note: 'deprecated: true in the contract; no Sunset/Deprecation header is emitted at runtime and no sunset date is published.'
- target: $.info
description: 'Record the rate-limit gap: 429 is declared but no machine-readable retry signal accompanies it.'
update:
x-rate-limit-gap: This document declares 429 responses but attaches no Retry-After and no RateLimit-* headers, so a client has no server-supplied
backoff hint. See ../rate-limits/snowflake-rate-limits.yml.
Work with this as data
Every overlay 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 openapi overlays
4 MCP tools reach this
find_overlaysBrowse and filter every overlay 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 overlay
curl "https://apis.io/api/v1/overlays/snowflake-table-overlay"
All openapi overlays
curl "https://apis.io/api/v1/overlays?limit=25"
Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
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.