Snowflake
Read and add business data in your Snowflake database from a workflow.
Last updated
Read and add business data in your Snowflake database from a workflow.
Use the Snowflake node when your workflow needs data from a Snowflake database.
This node helps you:
find records from reporting or analytics tables
add new rows from workflow data
Teams often use this node to:
check reporting data before making a decision
retrieve customer or sales records for follow-up actions
send workflow results into a cloud data warehouse
The Action field gives you 2 options:
Query data from table — find or retrieve data from a selected table
Add data to table — create a new record in the table
Choose the Snowflake connection your workspace should use.
If you do not see the right connection, open Manage and add it in Workspace → Integrations.
Choose the table that contains the business data you want to use.
Examples include sales reports, customer records, operational summaries, or analytics tables.
Pick whether the workflow should read data or add data.
Choose Query data from table when you need to search or retrieve information.
This action includes SQL Generate Method with 2 options:
Use AI — describe what you want in plain language
Manual enter SQL — write the SQL query yourself
Choose Use AI if you want a faster setup and do not want to write SQL.
In Input, describe the result you want.
Examples:
Show total sales for this month
Find the latest order for this customer
Get open issues by region
Diaflow uses that instruction to generate the SQL query for you.
Choose Manual enter SQL if your team already has a specific query.
Enter the SQL in the code editor.
Use this option when you need exact control over filters, joins, or sorting.
Choose Add data to table when your workflow needs to save a new record.
This is useful when you want to:
send processed workflow data into reporting tables
store AI results for later analysis
capture operational events in a central warehouse
Make sure the values you send match the columns in the selected table.
Select resource — chooses the Snowflake connection
Table — chooses the table the node will use
Action — decides whether the node reads or adds data
SQL Generate Method — appears for query actions and lets you use AI or manual SQL
Input — plain-language instruction for AI-generated queries
Code editor — SQL entry area for manual queries
Start with Query data from table to confirm the connection works.
Use a simple reporting table first.
If you are not sure what to write, use Use AI before manual SQL.
Check the Result tab after each test run.
If you are unsure which table or fields to use, ask your database owner or technical team first.
Last updated