Snowflake

Use the Snowflake node to automate work in Snowflake, and integrate Snowflake with other applications. n8n has built-in support for a wide range of Snowflake features, including executing SQL queries, and inserting rows in a database.

On this page, you'll find a list of operations the Snowflake node supports and links to more resources.

Operations

• Execute an SQL query.
• Insert rows in database.
• Update rows in database.

Execute an SQL query

When executing SQL queries on Snowflake, you can use parameterized queries to safely pass values into your SQL statements.

Use query parameters

Use the Query Parameters field in the Options section to bind values to your query. n8n sanitizes data in query parameters, which prevents SQL injection.

In your SQL query, use placeholders $1, $2, $3, and so on to indicate where parameter values should be inserted. For example:

SELECT * FROM users WHERE email = $1 AND status = $2;

Then in Query Parameters, provide the values to bind. You can provide fixed values or expressions. Use expressions to pull data from input items:

{{ $json.email }}, {{ $json.status }}

Each parameter value should be separated by a comma. The first value binds to $1, the second to $2, and so on.

Templates and examples

Browse Snowflake node documentation integration templates or search all templates