Snowflake integration

Data warehouse built for the cloud. Use Snowflake from Zoft voice agents, chat agents, workflows and AI employees.

Sign in with OAuth
14 actions
5 triggers

Get early access Talk to sales

Starts withNew Row
ZoftAgent or workflow decides what happens next
Then in SnowflakeCreate / Refresh Dynamic Table
AndUpdate Row

Illustrative flow built from Snowflake’s real triggers and actions.

Zoft + Snowflake

What Zoft can do with Snowflake.

01Voice agentsA phone agent can use Snowflake actions such as Create / Refresh Dynamic Table and Update Row during the call, then hand off to a person when it should.
02Chat agentsThe same agent on web chat, WhatsApp or SMS can look up and update Snowflake while it talks to the customer.
03WorkflowsStart a workflow when “New Row” happens in Snowflake, or use Snowflake as any step on the canvas.
04AI employeesAn AI employee can find and use Snowflake actions on its own, and ask for your approval before it sends or changes anything important.

Actions 14

Things Zoft can do in Snowflake.

Run QueryExecute a SQL query against your Snowflake database and return the results as rows.
Delete RowDelete one or more rows from a Snowflake table that match a WHERE condition.
Insert RowInsert a row into a table.
Update RowUpdate one or more rows in a Snowflake table that match a WHERE condition.
Upsert RowInsert a new row or update an existing one if a row with the same match column value already exists (MERGE INTO).
List TablesList all tables in a Snowflake schema.
Search RowsSearch for rows in a Snowflake table using an optional WHERE condition, ordering, and row limit.
Get Row by IDRetrieve a single row from a Snowflake table by matching a column value.
Get Table SchemaRetrieve the column definitions (name, data type, nullability, default) for a Snowflake table.
Run Multiple QueriesExecute 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.

Show all 14

Create / Refresh Dynamic TableCreate 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.
Insert Multiple RowsInsert multiple rows into a Snowflake table in a single operation.
Load Data from StageLoad data into a Snowflake table from a named internal or external stage using COPY INTO.
Execute Stored ProcedureCall a stored procedure in Snowflake and return its result.

Triggers 5

Events in Snowflake that can start a workflow.

New RowTriggers 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 ViewTriggers when a new view is created in the selected schema. Checked by polling every few minutes.
New TableTriggers when a new table is created in the selected schema. Checked by polling every few minutes.
New ColumnTriggers when a new column is added to the selected table. Checked by polling every few minutes.
New or Updated RowTriggers 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.

Setup

Connect Snowflake in three steps.

01ConnectChoose Snowflake in Connections and approve access in the Snowflake sign-in window. Zoft never sees your password.
02Put it to workAdd Snowflake as a workflow step, or let a voice agent, chat agent or AI employee use it as a tool.
03Review every runAdd approvals where you want a person in the loop. Every run leaves a record you can check.

See all in Developer tools

FAQ

Snowflake on Zoft, answered.

What can Zoft do with Snowflake?

Zoft supports 14 actions and 5 triggers for Snowflake. You can use them as workflow steps, and voice agents, chat agents and AI employees can call them as tools.

How do I connect Snowflake to Zoft?

Choose Snowflake in Connections and approve access in the Snowflake sign-in window. Zoft never sees your password.

Can a voice agent or chat agent use Snowflake?

Yes. Once Snowflake is connected, a voice agent or chat agent can use its actions during a conversation. Permissions control which actions each agent can use.

Can an AI employee work in Snowflake without supervision?

Only as far as you allow. AI employees ask for approval before sensitive steps, and every run leaves a record you can review.

Put Snowflake to work in your operation.