Introduction to the 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:
Manage your deployment (e.g. provision users and roles, create tables, etc.).
Capabilities of the SQL API¶
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.
Fetch query results concurrently.
For queries, the SQL API returns data in partitions. Snowflake determines the number of partitions returned and the size of each partition.
The endpoint for the SQL API (
/api/v2/statements) is protected by the network policies
that restrict access to the account where the API is enabled.
The AUTOCOMMIT parameter must be set to
TRUE per query or statement level, regardless of the
value set at the user or account level.
Limitations of the SQL API¶
The SQL API has the following limitations:
The following commands are not supported:
The following commands and statements are supported only within a request that specifies multiple statements:
Commands that perform explicit transactions, including:
Commands that change the context of the session, including:
Statements that set session variables.
Statements that create temporary tables and stages (tables and stages that are available only in the current session).
The SQL API does not currently support Python stored procedures.