Snowflake

databases 15 tools available

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

Connect Snowflake Visit Snowflake

About this integration

Connect Snowflake to Definable to automate repetitive tasks, sync data with the rest of your stack, trigger on real-world events. Personas call Snowflake's 15 tools directly from chat or scheduled flows. You can wire it into any persona to read, write, and react when an event fires.

Connect Snowflake to Definable and it becomes a set of typed tools your agents plan with — triggered by events, run on schedules, or invoked mid-conversation. Every write is checked by the verifier before it lands.

Auth OAuth2 · 2 clicks

Tools 15 exposed

Plans All, incl. Free

Data Never trained on

Snowflake · in workflows

What teams actually run.

Three patterns teams run with Snowflake on day one. Each one is a plain-English prompt — no canvas, no glue code — and you can remix them into anything.

Trigger on event

│ Listen for a new event

│ Parse and validate the payload

└ Take an action with the linked tool

Daily summary

│ Pull yesterday's activity

│ Summarise with the model of your choice

└ Send the digest via email or Slack

Cross-tool sync

│ Read records from one app

│ Transform with a persona

└ Write the result back via this integration

15 tools available

The Snowflake toolbox.

Every Snowflake capability your agents can call, each with a typed schema the planner reads. The router picks the right tool per step; the verifier checks the result.

Cancel Statement Execution

Cancels the execution of a running SQL statement. Use this action to stop a long-running query.

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.

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.

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.

Get Active Scheduled Maintenances

Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.

Get All Scheduled Maintenances

Retrieves a list of the 50 most recent scheduled maintenances, including those in the Completed state.

Get Component Status

Retrieves the status of individual components, each listed with its current status.

Get Status Rollup

Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.

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.

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.

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.

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.

Show Schemas

Lists all schemas for which you have access privileges. Shows schema metadata including name, creation date, owner, database, retention time, and more. Can filter results and include dropped schemas within Time Travel retention period.

Show Tables

Lists all tables for which you have access privileges. Shows table metadata including name, creation date, owner, database, schema, row count, size in bytes, clustering keys, and more. Can filter results and include dropped tables within Time Travel retention period.

Submit SQL Statement (Deprecated)

DEPRECATED: Use ExecuteSql instead. Submits a SQL statement for execution. Execution is asynchronous; monitor status with SNOWFLAKE_CHECK_STATEMENT_STATUS for long-running queries.

See it run

One prompt, start to finish.

A real prompt, the Snowflake tools it calls, and what comes back. This is the whole interface — describe the outcome, agents handle the rest.

❯

Run a real Snowflake task end-to-end — plan it, execute across the API, and hand back a verified result.

snowflake.cancel_statement_execution Cancels the execution of a running SQL statement. Use this action to stop a long-running q

snowflake.check_statement_status Retrieves the status and results of a previously submitted SQL statement using its stateme

snowflake.execute_sql Execute SQL statements in Snowflake and retrieve results. Supports SELECT queries for data · verified

done

Done. Snowflake responded across 3 calls, the verifier signed off, and the result is logged with every payload.

FAQ · Snowflake

Questions, answered.

What teams ask before connecting Snowflake.

01 What can I automate with Snowflake on Definable?

Anything Snowflake exposes through its API. Common databases workflows on Definable include automate repetitive tasks, sync data with the rest of your stack, trigger on real-world events. Personas can call any of the 15 Snowflake tools directly, then chain the result into another integration without you writing code.

02 How does Snowflake authentication work?

Snowflake uses OAUTH2 on Definable. You connect once from the integrations page, scoped to the permissions you choose, and from then on any persona that has the integration enabled can act on your behalf. Tokens are encrypted at rest and rotated automatically.

03 Is the Snowflake integration included in my Definable plan?

Yes — every Definable plan, including Starter, includes access to all 15 Snowflake tools. You only need a separate Snowflake subscription if Snowflake itself charges per seat or per API call.

04 Is using Snowflake through Definable secure?

Every call from a persona to Snowflake is logged with the user, persona, prompt, and response. Tokens never leave Definable's secrets vault, scopes are configurable per persona, and you can revoke access at any time from the integration page.

05 How do I get started with Snowflake on Definable?

Sign up for Definable, open the integrations page, find Snowflake, and connect via OAuth or API key. You can immediately attach Snowflake to any persona and start running workflows. The free Starter plan includes 5,000 credits/month.

06 What Snowflake actions does Definable expose?

Definable exposes all 15 Snowflake actions as callable tools — including `Cancel Statement Execution`, `Check Statement Status`, `Execute SQL`, plus 12 more. Each tool gets a typed parameter schema so personas know exactly how to call it.