Snowflake SQL API

API

Execute warehouse SQL through Snowflake's REST API

Price: Consumption-based credits
Access: OAuth, JWT or programmatic token

About

The Snowflake SQL API submits SQL statements to a Snowflake account, returns query results, and supports checking or cancelling longer-running statements. Calls use a bearer token from OAuth, key-pair JWT or a programmatic access token.

What you can do with it

Query Snowflake warehouse tables from a custom application
Submit SQL transformations and data updates over HTTP
Check asynchronous statement status and fetch query results

Get started

Configure a Snowflake account and warehouse
Set up OAuth, key-pair JWT or a programmatic access token
Submit SQL to the account's statements endpoint

Example

curl -X POST "https://$SNOWFLAKE_ACCOUNT.snowflakecomputing.com/api/v2/statements" \
  -H "Authorization: Bearer $SNOWFLAKE_TOKEN" \
  -H "Accept: application/json" \
  -H "Content-Type: application/json" \
  -H "User-Agent: warehouse-app/1.0" \
  -d '{"statement":"SELECT CURRENT_VERSION()","warehouse":"YOUR_WAREHOUSE"}'

Details

Hosting: Hosted service
Available in: Worldwide
MCP server: Remote