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 statements API

The statements API from Snowflake — 3 operation(s) for statements.

Snowflake statements 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 Statements. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, a JSON-LD context, and 2 JSON Schemas.

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

Requests are made against 2 base URLs: https://{account}.snowflakecomputing.com, https://org-account.snowflakecomputing.com.

3 operations 3 paths 19 schemas 1 GET2 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.2.0
API Version
2.0.0
Base URL
https://{account}.snowflakecomputing.com
Authentication
HTTP Bearer, HTTP Bearer, OAuth 2.0, HTTP Bearer, HTTP Bearer, OAuth 2.0, HTTP Bearer
Resource Areas
1

Authentication & Security 7

Snowflake statements API declares 7 security schemes for authenticating requests. It accepts HTTP bearer tokens (JWT) (keyPair). It accepts HTTP bearer tokens (JWT) (externalOAuth). It supports OAuth 2.0 (snowflakeOAuth) using the authorizationCode flow, exposing 1 scope. It accepts HTTP bearer tokens (JWT) (ExternalOAuth). It accepts HTTP bearer tokens (JWT) (KeyPair). It supports OAuth 2.0 (SnowflakeOAuth) using the implicit flow. It accepts HTTP bearer tokens (JWT) (ProgrammaticAccessToken).

  • keyPair — Key pair authentication using a JWT token. Set X-Snowflake-Authorization-Token-Type to KEYPAIRJWT.
  • externalOAuth — External OAuth authentication. Configure External OAuth with Snowflake and set X-Snowflake-Authorization-Token-Type to OAUTH. Set the Token to the auth token r…
  • snowflakeOAuth — Snowflake OAuth authentication flow.
  • ExternalOAuth — Configure External Oauth with Snowflake (refer to docs). Set X-Snowflake-Authorization-Token-Type to OAUTH and set the Token to auth token received from the ex…
  • KeyPair — Set X-Snowflake-Authorization-Token-Type to KEYPAIRJWT if the token is a key pair authn JWT.
  • ProgrammaticAccessToken — Set X-Snowflake-Authorization-Token-Type to PROGRAMMATICACCESSTOKEN if the token is a programmatic access token.

Paths & Operations 3

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

statements 3
POST
/api/v2/statements
Submit a Sql Statement for Execution.
submitStatement 6 params body → 200202400401403404405408
GET
/api/v2/statements/{statementHandle}
Check the Status of the Execution of a Statement.
getStatementStatus 6 params → 200202400401403404405415
POST
/api/v2/statements/{statementHandle}/cancel
Cancel the Execution of a Statement.
cancelStatement 5 params → 200400401403404405422500

Schemas 19

The contract defines 19 schemas that model the data the API accepts and returns. The most detailed are SessionParameters (13 properties), ResultSet_2 (9 properties), ResultSet (9 properties), ResultSet_3 (9 properties). Each schema is shown below with its type and property counts.

ColumnDefinition
object
Describes a column in the result set.
6 properties
SessionParameters
object
Session parameters that should be set before executing the statement.
13 properties
CancelStatus
object
Status returned when a statement cancellation is requested.
5 properties 1 required
ResultSet
object
The result set returned from a successfully executed SQL statement, including metadata, row data, and execution statistics.
9 properties
QueryFailureStatus
object
Status returned when a query execution fails.
6 properties 2 required
StatementRequest
object
Request body for submitting a SQL statement for execution.
8 properties
QueryStatus
object
Status of a query that is in progress or has completed successfully.
6 properties 1 required
PartitionInfo
object
Information about a partition of the result set.
3 properties
ResultSetMetaData
object
Metadata about the result set including column definitions.
6 properties
ExecutionStats
object
Statistics about the execution of the statement. These stats might not be available for each request.
4 properties
BindVariable
object
A bind variable value with its Snowflake data type.
2 properties 2 required
CancelStatus_2
object
5 properties 1 required
ResultSet_2
object
9 properties
QueryFailureStatus_2
object
6 properties 2 required
QueryStatus_2
object
6 properties 1 required
CancelStatus_3
object
5 properties 1 required
ResultSet_3
object
9 properties
QueryFailureStatus_3
object
6 properties 2 required
QueryStatus_3
object
6 properties 1 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

snowflake-statements-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 statements 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.