# Snowflake integration

> Cloud data warehouse — execute SQL, manage databases/schemas/tables, and read service status via the Snowflake SQL API.

- Authentication: oauth2

## Tools (14)

- **Cancel Statement Execution**: Cancel a running SQL statement by its statement handle.
- **Check Statement Status**: Poll the status of an async SQL statement and fetch additional result-set partitions.
- **Execute SQL Statement**: Run a SQL statement (SELECT, DDL, or DML) and get the result set or statement handle.
- **Fetch Catalog Integration**: Get configuration for an external Apache Iceberg catalog integration (Glue, Polaris, or REST).
- **Get Active Scheduled Maintenances**: List scheduled maintenances currently in progress or being verified.
- **Get All Scheduled Maintenances**: List the 50 most recent scheduled maintenances including completed ones.
- **Get Component Status**: List the per-region/per-service components on Snowflake's status page with their current status.
- **Get Status Rollup**: Get the overall Snowflake status indicator (none/minor/major/critical) without component detail.
- **Get Status Summary**: Get the full Snowflake public status page summary — overall status, components, incidents, scheduled maintenances.
- **Get Unresolved Incidents**: List unresolved Snowflake incidents (Investigating, Identified, or Monitoring).
- **Get Upcoming Scheduled Maintenances**: List scheduled maintenances that are still in the Scheduled (not yet started) state.
- **Show Databases**: List databases accessible to the current role using SHOW DATABASES via the SQL API.
- **Show Schemas**: List schemas accessible to the current role using SHOW SCHEMAS via the SQL API.
- **Show Tables**: List tables accessible to the current role using SHOW TABLES via the SQL API.

## Related prompts

- [SQL Crafter: draft, explain, and review queries from your schema](https://www.generalinput.com/prompts/sql-crafter-draft-explain-and-review-queries-from-your-schema.md)
- [Sharpen and ship any data analysis](https://www.generalinput.com/prompts/sharpen-and-ship-any-data-analysis.md)
- [Daily Snowflake churn risk scores on every HubSpot contact](https://www.generalinput.com/prompts/daily-snowflake-churn-risk-scores-on-every-hubspot-contact.md)
- [Hourly Snowflake task failure tickets in Linear and Slack](https://www.generalinput.com/prompts/hourly-snowflake-task-failure-tickets-in-linear-and-slack.md)
- [Slack data Q&A bot powered by Snowflake](https://www.generalinput.com/prompts/slack-data-qa-bot-powered-by-snowflake.md)
- [Daily Snowflake cost watchdog in Slack](https://www.generalinput.com/prompts/daily-snowflake-cost-watchdog-in-slack.md)
- [Daily executive KPI digest in Slack from Snowflake](https://www.generalinput.com/prompts/daily-executive-kpi-digest-in-slack-from-snowflake.md)

Connect Snowflake in General Input: https://www.generalinput.com/apps/snowflake