Snowflake

Snowflake

Data warehouse built for the cloud

Snowflake currently provides 5 triggers that can start a workflow and 14 actions a workflow can run. Use those building blocks to connect product and engineering activity to the customers and work it affects.

Developer Tools5 triggers14 actions

Triggers

(5)

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.

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.

New Column

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

New Table

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

New View

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

Actions

(14)

Run Query

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

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.

Insert Row

Insert a row into a table.

Update Row

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

Delete Row

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

Upsert Row

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

Insert Multiple Rows

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

Get Row by ID

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

Search Rows

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

Get Table Schema

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

List Tables

List all tables in a Snowflake schema.

Execute Stored Procedure

Call a stored procedure in Snowflake and return its result.

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.

Load Data from Stage

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

What can you automate with Snowflake and Coherence?

These recipes are generated from the triggers, actions, and categories currently available for this piece. Use them as starting points, then choose the exact fields, conditions, and records your workflow should update.

Bring Snowflake activity into Coherence

Start from a supported Snowflake event, then create or update the appropriate CRM, project, or custom record with the source context preserved.

Starts with

New Row

Finishes with

Create or update a Coherence record

Act in Snowflake from a Coherence workflow

Use a change in Coherence to run a supported Snowflake action, so the next step follows the record instead of relying on someone to copy it.

Starts with

A Coherence record or workflow changes

Finishes with

Run Query

Connect Snowflake to the wider customer workflow

Combine Snowflake with another integration and Coherence records to connect product and engineering activity to the customers and work it affects.

Starts with

New Row

Finishes with

Run Query, then preserve the outcome in Coherence

How to connect Snowflake

The exact authentication fields depend on Snowflake. The workflow structure stays straightforward:

1

Connect the account

Authorize the Snowflake account and permissions the workflow needs.

2

Choose a supported step

Select one of the current triggers or actions listed above and map its fields.

3

Test with a real record

Run a small test, inspect the result in both systems, and only then enable the workflow.

Related integrations for the same workflow

Explore apps that share a category with Snowflake or provide a complementary trigger or action.

Snowflake integration questions

What can I automate with the Snowflake integration?

Snowflake currently provides 5 triggers that can start a workflow and 14 actions a workflow can run. Use those building blocks to connect product and engineering activity to the customers and work it affects.

How many Snowflake triggers and actions are available?

Snowflake currently lists 5 triggers and 14 actions in the integration catalog. The supported list is refreshed from the pieces available in Coherence, so review the capability names on this page before building a workflow.

Can Snowflake connect to other apps through Coherence?

Yes. A workflow can combine supported Snowflake triggers or actions with Coherence records and other available integrations. The exact flow depends on the authentication, permissions, triggers, and actions exposed by each connected app.

Do I need to write code to connect Snowflake?

The listed triggers and actions are designed for visual workflows. If the pre-built integration does not expose a capability you need, HTTP and webhook steps can cover APIs that your team is authorized to use.

Ready to connect Snowflake?

Start automating in minutes. No credit card required.