Skip to content
Snowflake logo

Snowflake integration

Data warehouse built for the cloud

Actions
14
Triggers
5
Auth
OAuth 2.0 or Custom auth
License
MIT, open source
Updated
August 2026

About the Snowflake integration

Add the Snowflake piece to a flow, connect your account once, and the rest of the builder can read from it and write to it. Because the piece is open source you can run it on our cloud or self-host it, and combine Snowflake with 760+ other apps in the same flow.

Triggers

Start a flow the moment something happens in Snowflake

Each trigger below can start a flow on its own, either instantly or on a schedule.

  • New Row

    Triggers when a new row is inserted into the selected table. Uses a timestamp column you choose to detect rows added since the last check.

    4 fields

  • New or Updated Row

    Triggers when a row is inserted or updated in the selected table. Uses an "updated at" timestamp column you choose — any row whose timestamp is newer than the last check will fire the trigger.

    4 fields

  • New Column

    Triggers when a new column is added to the selected table. Checked by polling every few minutes.

    3 fields

  • New Table

    Triggers when a new table is created in the selected schema. Checked by polling every few minutes.

    2 fields

  • New View

    Triggers when a new view is created in the selected schema. Checked by polling every few minutes.

    2 fields

Actions

Everything Activepieces can do in Snowflake

Drop any of these into a flow and fill in the fields. No code is required.

  • Run Query

    Execute a SQL query against your Snowflake database and return the results as rows.

    4 fields

  • Run Multiple Queries

    Execute multiple SQL statements in sequence against your Snowflake database. Optionally wrap them in a transaction so all changes are rolled back if any statement fails.

    5 fields

  • Insert Row

    Insert a row into a table.

    4 fields

  • Update Row

    Update one or more rows in a Snowflake table that match a WHERE condition.

    5 fields

  • Delete Row

    Delete one or more rows from a Snowflake table that match a WHERE condition.

    4 fields

  • Upsert Row

    Insert a new row or update an existing one if a row with the same match column value already exists (MERGE INTO).

    5 fields

  • Insert Multiple Rows

    Insert multiple rows into a Snowflake table in a single operation.

    4 fields

  • Get Row by ID

    Retrieve a single row from a Snowflake table by matching a column value.

    5 fields

  • Search Rows

    Search for rows in a Snowflake table using an optional WHERE condition, ordering, and row limit.

    6 fields

  • Get Table Schema

    Retrieve the column definitions (name, data type, nullability, default) for a Snowflake table.

    3 fields

  • List Tables

    List all tables in a Snowflake schema.

    2 fields

  • Execute Stored Procedure

    Call a stored procedure in Snowflake and return its result.

    4 fields

  • Create / Refresh Dynamic Table

    Create or replace a Snowflake Dynamic Table that automatically refreshes based on a query. Dynamic Tables are a declarative way to define a table whose content is derived from a query, updated on a schedule.

    6 fields

  • Load Data from Stage

    Load data into a Snowflake table from a named internal or external stage using COPY INTO.

    9 fields

Use Snowflake in a flow

Connect Snowflake once and every trigger and action above is yours to drop into the builder, alongside 760+ other apps. Free to start, on our cloud or your own servers.

Snowflake, answered.

Yes. Activepieces is open source and free to start, and the Snowflake piece is included on every plan, from the free cloud tier to any self-hosted deployment.

Add the Snowflake piece to a flow, then authenticate with OAuth 2.0 or Custom auth. Once connected, its 5 triggers and 14 actions are available anywhere in the builder.

"New Row" can start a flow that runs "Run Query", and you can chain Snowflake together with any of 760+ other apps and AI steps in between.

Yes. Activepieces is fully self-hostable, so you can run the Snowflake piece on your own infrastructure with your connections and your data staying in your environment.

Yes. Every piece you connect can be exposed over one Activepieces MCP server, so Claude, Cursor, Windsurf or any MCP client can call Snowflake actions as tools.