Connect Snowflake to AI agents

Connect Snowflake to Claude, Codex, Cursor, or other AI agents for your entire team. Metorial security, governance, observability, and gives your team a unified Magic MCP url to connect.

Deploy SnowflakeBook a demo

Supported Triggers

Tools11Triggers3

task_run_completed

Task Run Completed

Triggers when a scheduled Snowflake task completes a run. Polls the task history to detect task run completions, including both successful and failed runs.

query_completed

Query Completed

Triggers when SQL queries complete execution in the Snowflake account. Polls the query history to detect newly completed queries including both successful and failed executions.

inbound_webhook

Inbound Webhook

Receives HTTP POST at the Slates webhook URL. Parses JSON into payload (or stores raw body if not JSON). Configure your provider to POST here when supported.

More integrations teams use with Snowflake

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Subscribe to webhooks for list and library change notifications. Retrieve site properties and search for sites across Microsoft 365.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Subscribe to real-time change events via Change Data Capture and Platform Events. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Bitbucket

Manage Git repositories, pull requests, and CI/CD pipelines on Bitbucket Cloud. Create, fork, and configure repositories within workspaces and projects. Create, review, approve, merge, and decline pull requests with inline code comments. Browse source code, list commits, and manage branches and tags. Track issues with the built-in issue tracker. Trigger, monitor, and manage Bitbucket Pipelines. List workspace members, configure repository default reviewers and branch restrictions, create and manage repository webhooks, and search code across repositories.

Heroku

Deploy, manage, and scale applications on Heroku's cloud platform. Create and configure apps, scale dynos, provision add-ons (databases, caching, etc.), manage configuration variables, build and release code, add custom domains and SSL certificates, manage collaborators and team permissions, configure pipelines for continuous delivery, set up log drains, and sync data with Salesforce via Heroku Connect. Subscribe to webhooks for real-time notifications on app changes, builds, releases, dyno lifecycle events, and more.

How to use Snowflake on Metorial

Aggregate Snowflake Revenue Data into Microsoft Fabric for Finance Reporting

The agent queries Snowflake for monthly revenue, churn, and expansion metrics, stages the results in Microsoft Fabric's OneLake, and triggers a Data Factory pipeline to refresh the finance reporting dataset.

Send SMS Alerts via Twilio When Snowflake Anomaly Queries Detect Data Issues

The agent runs scheduled anomaly detection queries against Snowflake to check for data quality issues such as null spikes, row count drops, or unexpected value distributions, and sends SMS alerts via Twilio to the on-call data engineer when thresholds are breached.

Technical notes for Snowflake

Execute SQL statements and manage cloud data warehouse resources on Snowflake. Run queries synchronously or asynchronously, manage databases, schemas, tables, warehouses, users, roles, grants, tasks, stages, streams, and pipes. Ingest data via Snowpipe batch loading or Snowpipe Streaming for low-latency continuous ingestion. Access Cortex AI services for search, inference, and embeddings. Configure outbound notifications to Slack, Microsoft Teams, PagerDuty, email, or cloud queues (SNS, PubSub, Event Grid). Supports multi-statement transactions, resource creation and alteration without SQL, and dynamic tables.

Connect Snowflake to production AI agents

See how Metorial gives Snowflake access the governance, tracing, and security controls teams need.

Book a demoDeploy Snowflake

Frequently asked questions

Common questions about connecting Snowflake to AI agents with Metorial.

  1. Can Metorial connect Snowflake to AI agents?
    Yes. Metorial connects AI agents to Snowflake through a governed integration layer, so teams can use the provider while keeping access controlled and observable.
  2. Metorial is MCP compatible and lets teams expose approved provider tools to MCP-capable agents and clients through a controlled access layer.
  3. Metorial applies policies across users, groups, providers, agents, and individual tools, then records the context around every agent interaction.
  4. Yes. Metorial records provider activity so teams can inspect tool calls, troubleshoot integrations, and give security teams the visibility they need.