Snowflake SQL 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.