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:

Field
Value

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)

Note: You need to enter at least one of the two optional fields

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)

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

  • 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

Action Name
Description
Key Inputs
Key Outputs

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?