Snowflake

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.