Snowflake

Execute SQL queries and manage warehouses via the Snowflake SQL API.

Environment Variables

• SNOWFLAKE_ACCOUNT - Account identifier (e.g. abc12345.us-east-1)
• SNOWFLAKE_USER - Username
• SNOWFLAKE_PASSWORD - Password

Execute SQL

curl -s -X POST \
  "https://$SNOWFLAKE_ACCOUNT.snowflakecomputing.com/api/v2/statements" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $SNOWFLAKE_PASSWORD" \
  -d '{"statement":"SELECT * FROM my_table LIMIT 10","warehouse":"COMPUTE_WH","database":"MY_DB","schema":"PUBLIC"}' | jq '{statementHandle, data: .data[:5]}'

List databases

curl -s -X POST \
  "https://$SNOWFLAKE_ACCOUNT.snowflakecomputing.com/api/v2/statements" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer $SNOWFLAKE_PASSWORD" \
  -d '{"statement":"SHOW DATABASES","warehouse":"COMPUTE_WH"}' | jq '.data[]'