> For the complete documentation index, see [llms.txt](https://docs.n8n.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.snowflake.md).

# Snowflake

Learn how to use the Snowflake node in n8n. Follow technical documentation to integrate Snowflake node into your workflows.

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.

{% hint style="info" %}
**Credentials**

Refer to [Snowflake credentials](/integrations/builtin/credentials/snowflake.md) for guidance on setting up authentication.
{% endhint %}

## Operations <a href="#operations" id="operations"></a>

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

### Execute an SQL query <a href="#execute-an-sql-query" id="execute-an-sql-query"></a>

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

#### Use query parameters <a href="#use-query-parameters" id="use-query-parameters"></a>

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:

```sql
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:

```js
{{ $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.

{% hint style="warning" %}
**Security recommendation**

When your query includes any external or untrusted input, use query parameters instead of interpolating `{{ }}` expressions directly into the query string. This prevents SQL injection attacks by ensuring values are properly sanitized.
{% endhint %}

## Templates and examples <a href="#templates-and-examples" id="templates-and-examples"></a>

[Browse Snowflake node documentation integration templates](https://n8n.io/integrations/snowflake) or [search all templates](https://n8n.io/workflows/)