Snowflake SQL REST API

The Snowflake SQL API is a REST API that you can use to access and update data in a Snowflake database. You can use this API to develop custom applications and integrations that:

  • Perform queries

  • Manage your deployment (e.g. provision users and roles, create tables, etc.)

The Snowflake SQL API provides operations that you can use to:

  • Submit SQL statements for execution.

  • Check the status of the execution of a statement.

  • Cancel the execution of a statement.

You can use this API to execute standard queries and most DDL and DML statements. See Limitations of the SQL API for the types of statements that are not supported.

Introduction to the SQL API

Get an overview of the API.

About the SQL API endpoints

Learn about the endpoints that make up the API.

Authenticating to the server

Use OAuth or Key Pair to authenticate with the Snowflake server.

Submitting a request to execute SQL statements

Set up and submit requests using an API endpoint.

Handling responses

Check request status and get results and other data after a request.

Submitting multiple SQL statements in a single request

Send multiple SQL statements in a single API request.

Creating and calling stored procedures

Create a stored procedure by specifying it in the body of a request.

Using explicit transactions

Execute SQL in a transaction by specifying the start, end, and statements in the transaction.

Getting details about an error

Retrieve error information.

Canceling the execution of a SQL statement

Cancel SQL statement execution.

Snowflake SQL API reference

Read details about the operations, objects, HTTP headers, and response codes for this API.

Deprecated functionality

Learn about deprecated functionality.