Snowflake
This guide walks you through how to create a new connection to a Snowflake account
The Snowflake Node allows you to interact with a Snowflake database—either by querying data or inserting new records.
Connecting to Snowflake
Click the node to open its settings, then select New connection.
Enter the required connection details into the form according to the table and notes below:
Connection Name
This is whatever you want to name the connection
User
Your chosen Snowflake account username
Password (Optional)
Your chosen Snowflake account password
Private Key (Optional)
Only if using key-pair authentication
Account
nqxzcwd-ab12345
(see where to find below)
Warehouse
DUMMY_WAREHOUSE
(see where to find below)
Role
ACCOUNTADMIN
(see where to find below)
Database
DUMMY_DB
(see where to find below)
Schema
DUMMY_SCHEMA
(see where to find below)
Account
This is your account identifier. Find it here:


Warehouse
Find it here:

Role
Find it here:

Database
Find it here:

Schema
Find it here:

Available Actions
1. Query a Snowflake Database (database_query_snowflake
)
database_query_snowflake
)Description: Run queries against your Snowflake database and retrieve results.
Inputs:
sql_schema
(array of strings, required): The schema of your database (tables, columns, types, etc.). Example:TABLE MyTable (Name TEXT, Email TEXT, Weight REAL, Height REAL);
query
(string, required): The query you want to run. This can be in plain English or SQL. Example:"What is the total revenue for the year 2024?"
"Show me the top 10 customers by revenue"
"SELECT * FROM MyTable WHERE Name = 'John'"
Outputs:
sql_query
(string): The SQL query that was executed.results
(array of objects): The results of the query.
2. Insert Data into Snowflake (database_insert_snowflake
)
database_insert_snowflake
)Description: Insert new records into a table in your Snowflake database.
Inputs:
table_name
(string, required): The name of the table where you want to insert data.data
(object/dictionary, required): The data to insert, as key-value pairs where keys are column names and values are the data. Example:{ "name": "John Doe", "email": "[email protected]", "age": 30, "is_active": true }
Outputs:
sql_query
(string): The INSERT SQL query that was executed.rows_affected
(integer): Number of rows affected by the insert.success
(boolean): Whether the insert was successful.
Summary Table
Query Snowflake Database
Run queries and get results
sql_schema, query
sql_query, results
Insert Data into Snowflake
Insert new records into a table
table_name, data
sql_query, rows_affected, success
Last updated
Was this helpful?