Snowflake

Data warehouse built for the cloud

Developer tools

Connect it

In Keystile Automations → Connections → New connection, choose Snowflake and sign in. Your AI tools and workflows then use it through Keystile; they never see the password or key.How connecting works.

Try it from your AI tool

Using Keystile, in Snowflake: 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).

What it can do (14 actions)

Action	What it does	Changes data
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.
Delete Row	Delete one or more rows from a Snowflake table that match a WHERE condition.
Execute Stored Procedure	Call a stored procedure in Snowflake and return its result.
Get Row by ID	Retrieve a single row from a Snowflake table by matching a column value.
Get Table Schema	Retrieve the column definitions (name, data type, nullability, default) for a Snowflake table.
Insert Multiple Rows	Insert multiple rows into a Snowflake table in a single operation.
Insert Row	Insert a row into a table.
List Tables	List all tables in a Snowflake schema.
Load Data from Stage	Load data into a Snowflake table from a named internal or external stage using COPY INTO.
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.
Run Query	Execute a SQL query against your Snowflake database and return the results as rows.
Search Rows	Search for rows in a Snowflake table using an optional WHERE condition, ordering, and row limit.
Update Row	Update one or more rows in 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).

Start a workflow when… (5 triggers)

• 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.

How Keystile protects it

Every Snowflake action is checked before it runs, whether it comes from an AI tool or a workflow.your rules, limits and budgets decide whether each is allowed, held for a person or stopped, and it all goes into the signed record.

Tip

Write rules about what an action means — for example "Deleting Snowflake records needs a person's approval" — rather than listing action names. Keystile Intelligence applies them to every action that fits.

Use Snowflake with your AI assistant — safelyClaude, Cursor or ChatGPT do the work; Keystile checks every action first.

Get early access

← All apps