Snowflake
Data warehouse built for the cloud
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.
Example automation
Trigger
Event received
from Snowflake
Action
Create Module Record
in Coherence
Ready to connect Snowflake?
Start automating in minutes. No credit card required.