Snowflake

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:

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:

    Copy

    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:

    Copy

    {
      "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