# Snowflake AI integration on Definable

> Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments

## What this connects

Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments

Vendor: https://www.snowflake.com/en/

## Tools available

**15** tools available. First 12:

- `SNOWFLAKE_CANCEL_STATEMENT_EXECUTION` — Cancel Statement Execution — Cancels the execution of a running SQL statement. Use this action to stop a long-running query.
- `SNOWFLAKE_CHECK_STATEMENT_STATUS` — Check Statement Status — Retrieves the status and results of a previously submitted SQL statement using its statement handle. Use this to poll async queries submitted via SNOWFLAKE_SUBMIT_SQL_STATEMENT; call repeatedly until status is no longer pending. Use SNOWFLAKE_CANCEL_STATEMENT to abort a hanging query.
- `SNOWFLAKE_EXECUTE_SQL` — Execute SQL — Execute SQL statements in Snowflake and retrieve results. Supports SELECT queries for data retrieval, DDL statements (CREATE, ALTER, DROP) for schema management, and DML statements (INSERT, UPDATE, DELETE) for data modification. Returns comprehensive result metadata including column types, row counts, and execution status. Unquoted SQL identifiers are auto-uppercased by Snowflake — use matching case in `database`, `schema_name`, `warehouse`, and `role` parameters to avoid 'object not found' errors. Always apply explicit time-range filters and a LIMIT clause to unbounded SELECT queries to prevent large, slow result sets.
- `SNOWFLAKE_FETCH_CATALOG_INTEGRATION` — Fetch Catalog Integration — Retrieves detailed configuration and metadata for a specific catalog integration. Catalog integrations allow Snowflake to connect to external Apache Iceberg catalogs (AWS Glue, Snowflake Open Catalog/Polaris, or Apache Iceberg REST catalogs) to query Iceberg tables managed by those external systems.
- `SNOWFLAKE_GET_ACTIVE_SCHEDULED_MAINTENANCES` — Get Active Scheduled Maintenances — Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.
- `SNOWFLAKE_GET_ALL_SCHEDULED_MAINTENANCES` — Get All Scheduled Maintenances — Retrieves a list of the 50 most recent scheduled maintenances, including those in the Completed state.
- `SNOWFLAKE_GET_COMPONENT_STATUS` — Get Component Status — Retrieves the status of individual components, each listed with its current status.
- `SNOWFLAKE_GET_STATUS_ROLLUP` — Get Status Rollup — Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.
- `SNOWFLAKE_GET_STATUS_SUMMARY` — Get Status Summary — Retrieves the current status summary from Snowflake's public status page (status.snowflake.com). Returns overall system status, operational status of all regional components (AWS, Azure, GCP regions), any unresolved incidents, and upcoming or in-progress scheduled maintenances. This is a public endpoint that provides global Snowflake service status, not account-specific information.
- `SNOWFLAKE_GET_UNRESOLVED_INCIDENTS` — Get Unresolved Incidents — Retrieves a list of any unresolved incidents from the Snowflake status page. This endpoint returns incidents currently in the Investigating, Identified, or Monitoring state. Returns an empty list if there are no active incidents. This is a public status page API that does not require authentication.
- `SNOWFLAKE_GET_UPCOMING_SCHEDULED_MAINTENANCES` — Get Upcoming Scheduled Maintenances — Retrieves upcoming scheduled maintenances from Snowflake's public status page. This action queries the Snowflake status API to get a list of any scheduled maintenance events that are still in the 'Scheduled' state (not yet started or completed). The response includes maintenance details such as impact level, scheduled time windows, incident updates, and direct links to the maintenance notices. Note: This uses Snowflake's public status API and does not require authentication.
- `SNOWFLAKE_SHOW_DATABASES` — Show Databases — Lists all databases for which you have access privileges. Shows database metadata including name, creation date, owner, retention time, and more. Can filter results and include dropped databases within Time Travel retention period.

## Auth

Auth schemes: `OAUTH2`.

## How agents use Snowflake

Inside a Definable workflow, Snowflake is one of the tools the **Distributor specialist** can call. Example coordination patterns:

- **Researcher → Snowflake** — the Researcher (GPT-5.5) pulls context from Snowflake (records, threads, documents), synthesises findings, and briefs the rest of the team.
- **Writer → Distributor → Snowflake** — the Writer (Claude Opus 4.7) drafts copy in brand voice, the Verifier passes it, then the Distributor writes the result into Snowflake (create record, post message, draft email).
- **Designer / Engineer → Distributor → Snowflake** — the Designer ships an asset or the Engineer ships a code change, the Distributor delivers it via Snowflake (attach file, open PR comment, post status).

The Verifier checks every Snowflake call. On rate limit, schema drift, or auth refresh it self-heals and retries — the workflow completes without manual intervention.

## Categories

- databases — https://definable.ai/apps/category/databases/
- analytics — https://definable.ai/apps/category/analytics/

## Related

- HTML page: https://definable.ai/apps/snowflake/
- Same category (databases): https://definable.ai/apps/category/databases/
- All integrations: https://definable.ai/apps/
- Workflow (multi-agent loop): https://definable.ai/workflow/
- Apps llms.txt index: https://definable.ai/llms-apps.txt