Query data, ask Cortex Analyst, and manage warehouses and tasks in Snowflake
Snowflake is a Sim integration in the Databases category. Sim is the AI workspace where teams build and deploy AI agents. Sim's Snowflake integration provides 32 tools that AI agents can use inside Sim's visual workflow builder. Snowflake connects with an API key. Free to start at sim.ai.
Last updated
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.
Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.
Open your workspace, drag a Snowflake block onto the workflow builder, and paste in your Snowflake API key.
Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Snowflake automation is live.
Ready-to-use templates featuring Snowflake. Click any to build it instantly.
32 Snowflake tools available to Sim agents.
Execute one parameterized SQL statement through the Snowflake SQL API.
Check a running or completed statement and retrieve exactly one result partition. Canceled or failed statements are returned as errors.
Cancel a running Snowflake SQL API statement.
Insert structured JSON rows using bound values.
Update matching rows with a bound MERGE statement without inserting new rows.
Update matching rows and insert unmatched rows with a bound MERGE statement.
Delete rows matching a required set of bound column filters.
Load files from an existing Snowflake stage with COPY INTO.
Export a Snowflake table to files in a stage with COPY INTO.
List the databases the credential can access.
List the schemas in a Snowflake database.
List the tables in a Snowflake schema.
List warehouses visible to the active Snowflake role.
Get the full details for a Snowflake virtual warehouse.
Resume a Snowflake virtual warehouse if it is suspended.
Suspend a Snowflake virtual warehouse.
Resize a Snowflake warehouse or change its auto-suspend and auto-resume settings.
List tasks in a Snowflake schema.
Describe a Snowflake task.
Run a Snowflake task immediately, optionally retrying its last failed graph.
Resume a suspended Snowflake task so its schedule runs again.
Suspend a Snowflake task so its schedule stops triggering runs.
Query up to seven days of Snowflake task history, capped at 10000 rows.
Find one task history record by query ID within Snowflake’s seven-day window and 10000 most recent records after optional filters.
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.
Read a task query result with RESULT_SCAN during Snowflake’s 24-hour retention window using the task owner role.
List queries that completed in the last seven days, optionally filtered.
List staged-file load results for a table over the last fourteen days.
Inspect table and column metadata through Snowflake INFORMATION_SCHEMA views.
Call a stored procedure with explicitly typed Snowflake bindings.
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.
Rate a Cortex Analyst answer thumbs up or down, with an optional comment. Feedback appears in the Snowsight Cortex Analyst monitoring tab.
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.
