How do I connect Snowflake to Operator?

Connecting Snowflake is a one time sign in from your Operator dashboard. Operator keeps the connection live and rotates the token on its own, so the agent stays connected to Snowflake and you never reauthorize by hand.

Can my agent pull and update data in Snowflake?

Yes. It can read records, write new ones, and answer questions about what is stored. Point it at Snowflake and ask for a figure or a list, or have it keep a table in step with another app you have connected, all in plain language.

Do I need to write code or manage Snowflake API keys?

No. Operator manages the Snowflake connection and token refresh, so there are no API keys to paste and nothing to deploy.

Can my agent use Snowflake together with my other apps?

Yes. The same agent reaches every app you connect, so it can move between Snowflake and tools like Posthog, Gosquared, Google Analytics in one job, reading from one and acting in another without you wiring anything between them.

← All integrations

Connect Snowflake to OpenClaw on Operator.io

Snowflake is a cloud data warehouse built for elastic scaling, secure data sharing, and fast SQL analytics across major clouds.

Analytics & Data14 actions

Try for free

Automate Snowflake with AI

Operator runs your personal agent on OpenClaw, the open source agent framework, and points it straight at Snowflake. You message the agent on Telegram or Discord, tell it what you need in plain language, and it operates Snowflake on its own, running actions like cancel statement execution, check statement status, execute sql.

Your agent reaches Snowflake directly or through connectors like Composio MCP and Pipedream MCP, which handle the sign in and token refresh for you, so there is nothing to wire up and no API keys to paste.

What your agent can do with Snowflake

Your agent can call any of these Snowflake actions by name as part of a larger task. Ask for the outcome you want and it picks the right ones.

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 SNOW...

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...

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 catal...

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 upcomi...

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...

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 com...

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...

How to connect Snowflake

You authorize Snowflake once from your dashboard. Operator holds the connection and refreshes the access tokens on its own, so your agent keeps working with Snowflake without you signing in again. The same setup unlocks every other app your agent can reach, so you only do it once.

When you are ready, the get started guide walks through standing up your OpenClaw agent.

Common questions about Snowflake

How do I connect Snowflake to Operator?: Connecting Snowflake is a one time sign in from your Operator dashboard. Operator keeps the connection live and rotates the token on its own, so the agent stays connected to Snowflake and you never reauthorize by hand.
Can my agent pull and update data in Snowflake?: Yes. It can read records, write new ones, and answer questions about what is stored. Point it at Snowflake and ask for a figure or a list, or have it keep a table in step with another app you have connected, all in plain language.
Do I need to write code or manage Snowflake API keys?: No. Operator manages the Snowflake connection and token refresh, so there are no API keys to paste and nothing to deploy.
Can my agent use Snowflake together with my other apps?: Yes. The same agent reaches every app you connect, so it can move between Snowflake and tools like Posthog, Gosquared, Google Analytics in one job, reading from one and acting in another without you wiring anything between them.