Connect Snowflake to your AI agent

Developer Tools 16 actions available

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

We set up the connection using your own Snowflake account, with keys you control, and keep it running. Your agent picks it up and starts doing the work.

Book a setup call → See pricing
Actions

What your agent can do in Snowflake

Each one is a real action the agent can take on its own, the same things a person clicking around Snowflake could do. Read-only by default; write actions are confirmed against your policy.

  • 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…
  • Drop Warehouse Drops (permanently deletes) a warehouse in Snowflake. This operation is irreversible — once a warehouse is dropped, it cannot be recovered. Use this action when you need to permanently remove a warehouse that is no long…
  • 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 modi…
  • 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…
  • 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 inc…
  • 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…
  • 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…
  • 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 reten…
  • 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 r…
  • 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 dro…
  • 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.
  • Validate Credential Validates Snowflake credentials by executing a lightweight test query. Returns session information if credentials are valid, or error details if authentication fails. Use this action when you need to verify that API cre…
Setup

How we connect it

  1. 1

    Connect your account

    You log in with your own Snowflake account. We never see your password, and you can revoke access from Snowflake at any time.

  2. 2

    Set the guardrails

    Read-only by default. You choose which write actions the agent may take, and anything outside that policy gets confirmed with you first.

  3. 3

    We keep it running

    Health checks on every connection, updates handled for you, and we watch the first week of activity to make sure the work lands.

FAQ

Snowflake questions, answered.

You sign in with your own Snowflake account. Permissions are scoped to the minimum the agent needs, the connection is health-checked, and you can revoke access from Snowflake at any time.
The actions Snowflake's API allows, the same things a person clicking around the app could do. Connections start read-only by default; write actions are confirmed against the policy you set before the agent takes them.
Connections are priced per tool on top of the base plan. Some are included, some are premium. See pricing for how connection charges work.
Standard tools are ready inside 7 business days of the setup call. We test the connection end to end, walk you through how the agent uses it, and watch the first week of activity.

Ready to put Snowflake to work?

Tell us what your team runs on. We set up the connection, secure it, and your agent takes it from there.

Book a setup call → Browse all integrations

All product names, logos, and brands are property of their respective owners; used for identification only. ZeroToClaw is not affiliated with or endorsed by Snowflake.