> 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

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