[ Developer tools ]
Snowflake integration for your workflows.
Connect Snowflake to Collabase once and use 14 actions and 5 triggers in your workflows. No code needed, hosted in Switzerland.
Snowflake in Collabase
Connect Snowflake to Collabase once and use 14 actions and 5 triggers in your workflows. No code needed, hosted in Switzerland.
[ About the service ]
Data warehouse built for the cloud
How to connect it
- Open the integrations in the workspace settings.
- Choose Snowflake and connect your account.
- Add a trigger or an action to the workflow.
Snowflake triggers
| Name | Description | Fields |
|---|---|---|
| New RowChecks at intervals | 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 RowChecks at intervals | 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 ColumnChecks at intervals | Triggers when a new column is added to the selected table. Checked by polling every few minutes. |
|
| New TableChecks at intervals | Triggers when a new table is created in the selected schema. Checked by polling every few minutes. |
|
| New ViewChecks at intervals | Triggers when a new view is created in the selected schema. Checked by polling every few minutes. |
|
Snowflake actions
| Name | Description | Fields |
|---|---|---|
| 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. |
+ 3
|
[ Developer tools ]
Related integrations
Tools that often share a workflow.
Questions about Snowflake
What can I automate with Snowflake in Collabase?
Snowflake brings 14 actions and 5 triggers, for example Run Query, Run Multiple Queries, Insert Row, Update Row and 10 more. You combine them in a workflow without code and mix them with every other integration.
How do I connect Snowflake to Collabase?
You open the integrations in the workspace settings, choose Snowflake and connect your account once, using OAuth 2.0. After that all triggers and actions are available in the workflow.
Can Snowflake start a workflow?
Yes. Snowflake provides 5 triggers, for example New Row, New or Updated Row, New Column and 2 more. The workflow runs as soon as the event happens.
Does the Snowflake integration cost extra?
No. All integrations are included in every licence, in the Isolated Cloud and in Self-Hosted operation. There is no module price.
Test it against your own content. A proof of concept is ready within days.
We set up an instance with your content and you test it against real workflows. In a first conversation we clarify scope, operating model and timing.