What can I automate with Snowflake in Sim?

You can execute SQL, get statement, cancel statement, insert rows, and update rows with Snowflake in Sim, plus 27 more Snowflake tools listed on this page. Each runs as a tool inside an AI agent, so the agent can combine Snowflake with any other connected service and apply LLM reasoning between steps.

How do I connect Snowflake to Sim?

(1) Create a free account at sim.ai. (2) Create an agent in your workspace. (3) Drag a Snowflake block onto the workflow builder. (4) Paste your Snowflake API key to authenticate. (5) Pick a tool such as "Execute SQL", wire up its inputs, and click Run.

How do I execute SQL with Snowflake in Sim?

Add a Snowflake block to your agent and select "Execute SQL" as the tool. Execute one parameterized SQL statement through the Snowflake SQL API. Fill in the required fields. Inputs can reference outputs from earlier steps, such as text generated by an AI block or data fetched from another integration.

Back to Integrations

Snowflake integration for AI agents

Query data, ask Cortex Analyst, and manage warehouses and tasks in Snowflake

View docs

Last updated September 26, 2026

What Sim agents can do with Snowflake

Connect with a Snowflake programmatic access token to execute SQL, synchronize structured rows, load and unload staged data, browse databases and schemas, size and control warehouses, run and schedule tasks, review query and load history, inspect schemas, and call stored procedures. Ask Cortex Analyst questions in natural language against a semantic view or model to get generated SQL and, optionally, its results, with multi-turn follow-ups.

Category: Databases
Authentication: API key
Tools: 32
Triggers: 0
Documentation: Snowflake docs

How to automate Snowflake with Sim

Create a free account
Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.
Add a Snowflake block
Open your workspace, drag a Snowflake block onto the workflow builder, and paste in your Snowflake API key.
Configure, connect, and run
Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Snowflake automation is live.

Agent templates

Ready-to-use templates featuring Snowflake. Click any to build it instantly.

Snowflake tools

32 Snowflake tools available to Sim agents.

Execute SQL

Execute one parameterized SQL statement through the Snowflake SQL API.

Get Statement

Check a running or completed statement and retrieve exactly one result partition. Canceled or failed statements are returned as errors.

Cancel Statement

Cancel a running Snowflake SQL API statement.

Insert Rows

Insert structured JSON rows using bound values.

Update Rows

Update matching rows with a bound MERGE statement without inserting new rows.

Upsert Rows

Update matching rows and insert unmatched rows with a bound MERGE statement.

Delete Rows

Delete rows matching a required set of bound column filters.

Load Data

Load files from an existing Snowflake stage with COPY INTO.

Unload Data

Export a Snowflake table to files in a stage with COPY INTO.

List Databases

List the databases the credential can access.

List Schemas

List the schemas in a Snowflake database.

List Tables

List the tables in a Snowflake schema.

List Warehouses

List warehouses visible to the active Snowflake role.

Get Warehouse

Get the full details for a Snowflake virtual warehouse.

Resume Warehouse

Resume a Snowflake virtual warehouse if it is suspended.

Suspend Warehouse

Suspend a Snowflake virtual warehouse.

Alter Warehouse

Resize a Snowflake warehouse or change its auto-suspend and auto-resume settings.

List Tasks

List tasks in a Snowflake schema.

Get Task

Describe a Snowflake task.

Run Task

Run a Snowflake task immediately, optionally retrying its last failed graph.

Resume Task

Resume a suspended Snowflake task so its schedule runs again.

Suspend Task

Suspend a Snowflake task so its schedule stops triggering runs.

List Task Runs

Query up to seven days of Snowflake task history, capped at 10000 rows.

Get Task Run

Find one task history record by query ID within Snowflake’s seven-day window and 10000 most recent records after optional filters.

Cancel Task Query

Cancel one running task query by query ID with SYSTEM$CANCEL_QUERY. Task runs already in flight are unaffected and must be cancelled individually; a cancelled child marks the task graph run failed, so downstream tasks are skipped.

Get Task Run Output

Read a task query result with RESULT_SCAN during Snowflake’s 24-hour retention window using the task owner role.

List Query History

List queries that completed in the last seven days, optionally filtered.

List Copy History

List staged-file load results for a table over the last fourteen days.

Introspect Schema

Inspect table and column metadata through Snowflake INFORMATION_SCHEMA views.

Call Procedure

Call a stored procedure with explicitly typed Snowflake bindings.

Ask Cortex Analyst

Ask Snowflake Cortex Analyst a question in natural language against a semantic view or semantic model. Returns its interpretation and the generated SQL, or suggested questions when the question is ambiguous, and can run the SQL to return rows. Pass the returned conversation as history to ask a follow-up.

Send Cortex Analyst Feedback

Rate a Cortex Analyst answer thumbs up or down, with an optional comment. Feedback appears in the Snowsight Cortex Analyst monitoring tab.

Frequently asked questions

Sim's Snowflake integration adds 32 tools to the AI agents you build in Sim's visual workflow builder. Query data, ask Cortex Analyst, and manage warehouses and tasks in Snowflake.