Cancel Statement Execution
Cancels the execution of a running SQL statement. Use this action to stop a long-running query.
ActionTry it
Integrate Snowflake
with your AI CRM
Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments
Explore Triggers and Actions
Check Statement Status
Checks a submitted SQL statement by handle and retrieves results for a completed statement, optionally for a specified partition. If execution is still in progress, the tool reports an execution error indicating that it should be retried.
ActionTry it
Drop Warehouse
Drops a Snowflake warehouse by its case-sensitive name. Requires OWNERSHIP privilege on the warehouse. Optionally use the if-exists condition to avoid an error when the warehouse is absent.
ActionTry it
Execute SQL
Submits SQL statements to Snowflake, including SELECT, DDL, and DML. Completed single-statement responses may include result rows and metadata; long-running statements may return a handle, and multi-statement responses provide handles for individual results.
ActionTry it
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.
ActionTry it
Get Active Scheduled Maintenances
Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.
ActionTry it
Get All Scheduled Maintenances
Retrieves up to 10 of the 50 most recent scheduled maintenances from Snowflake's status page, including completed events.
ActionTry it
Get Component Status
Retrieves the status of individual components, each listed with its current status.
ActionTry it
Get Status Rollup
Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.
ActionTry it
Get Status Summary
Retrieves Snowflake's public status summary, including overall status, component statuses, unresolved incidents, and upcoming or in-progress maintenance. Returns at most 50 components and 10 incidents and maintenances each; this is global service status, not account-specific information.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
Show Tables
Lists accessible Snowflake tables in the requested scope, with metadata, filters, and optional dropped-table history. Results may be incomplete: only the initial response is returned, and an in-progress response can appear as an empty list.
ActionTry it
Submit SQL Statement (Deprecated)
DEPRECATED: Submits a SQL statement to Snowflake for execution. Results may be returned immediately; longer-running statements may return a handle for status checks.
ActionTry it
Validate Credential
Checks Snowflake credentials by submitting a lightweight session query, useful before running other account operations. Returns a validity flag, a session ID when available, and a status message. Basic authentication is not supported for this check.
ActionTry it
How the Snowflake integration works
The Snowflake integration connects your Dench AI CRM directly to Snowflake, so agents can read and act on your Snowflake data as part of everyday work — answering questions in chat, keeping your CRM in sync, and running automations without anyone copying data between tools.
17 actions are available for agents to invoke on your behalf. Every call runs through Snowflake's own authorization, scoped to the account you connect.
Set up Snowflake in Dench
- 1
Sign in to your Dench workspace and open Integrations.
- 2
Find Snowflake and click Connect — you'll authorize access through Snowflake's own sign-in flow. No API keys or code required.
- 3
Ask an agent to use Snowflake in chat, or call it from an automation.
- 4
Manage or disconnect the connection any time from workspace settings.
Frequently asked questions
How does the Snowflake integration work with Dench?
The Dench Snowflake integration connects your AI CRM to Snowflake, so AI agents can work with your Snowflake data as part of chats, automations, and CRM workflows. You connect your account once, and every agent in your workspace can use it — governed by your workspace permissions.
What actions can AI agents perform with Snowflake via Dench?
The Snowflake integration currently exposes 17 actions, including Cancel Statement Execution, Check Statement Status, Drop Warehouse, Execute SQL, Fetch Catalog Integration, and Get Active Scheduled Maintenances. Agents invoke them on your behalf from chat or from automations.
Do I need to write code to connect Snowflake to Dench?
No. You connect Snowflake from your Dench workspace using Snowflake's own sign-in and authorization flow — no API keys to copy, no glue code to maintain.
Is the Snowflake integration secure?
Connections are authorized through Snowflake's own authentication flow, and Dench stores only the authorization needed to act on your behalf. You can review and disconnect the Snowflake connection from your workspace settings at any time.