Snowflake SQL API

API

Execute warehouse SQL through Snowflake's REST API

Fiyat: Consumption-based credits
Erişim: OAuth, JWT or programmatic token

Hakkında

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.

Neler yapabilirsin

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

Başlarken

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

Örnek kod

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"}'

Ayrıntılar

Barındırma: Hazır hizmet (bulut)
Kullanılabildiği yerler: Tüm dünya
MCP sunucusu: Uzak sunucu