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

# Snowflake

## What this node helps you do

Use the **Snowflake** node when your workflow needs data from a Snowflake database.

This node helps you:

* find records from reporting or analytics tables
* add new rows from workflow data

<figure><img src="/files/cmBjtTJGPruVAG5ljMVp" alt=""><figcaption></figcaption></figure>

### Common business examples

Teams often use this node to:

* check reporting data before making a decision
* retrieve customer or sales records for follow-up actions
* send workflow results into a cloud data warehouse

## Available actions

The **Action** field gives you 2 options:

* **Query data from table** — find or retrieve data from a selected table
* **Add data to table** — create a new record in the table

<figure><img src="/files/irQq7sXbiAkj3cITQL7a" alt=""><figcaption></figcaption></figure>

## Basic setup

### 1. Select resource

Choose the Snowflake connection your workspace should use.

If you do not see the right connection, open **Manage** and add it in **Workspace → Integrations**.

### 2. Select table

Choose the table that contains the business data you want to use.

Examples include sales reports, customer records, operational summaries, or analytics tables.

### 3. Choose the action

Pick whether the workflow should read data or add data.

## Query data from table

Choose **Query data from table** when you need to search or retrieve information.

This action includes **SQL Generate Method** with 2 options:

* **Use AI** — describe what you want in plain language
* **Manual enter SQL** — write the SQL query yourself

### Use AI

Choose **Use AI** if you want a faster setup and do not want to write SQL.

In **Input**, describe the result you want.

Examples:

* `Show total sales for this month`
* `Find the latest order for this customer`
* `Get open issues by region`

Diaflow uses that instruction to generate the SQL query for you.

### Manual enter SQL

Choose **Manual enter SQL** if your team already has a specific query.

Enter the SQL in the code editor.

Use this option when you need exact control over filters, joins, or sorting.

## Add data to table

Choose **Add data to table** when your workflow needs to save a new record.

This is useful when you want to:

* send processed workflow data into reporting tables
* store AI results for later analysis
* capture operational events in a central warehouse

Make sure the values you send match the columns in the selected table.

## Field reference

* **Select resource** — chooses the Snowflake connection
* **Table** — chooses the table the node will use
* **Action** — decides whether the node reads or adds data
* **SQL Generate Method** — appears for query actions and lets you use AI or manual SQL
* **Input** — plain-language instruction for AI-generated queries
* **Code editor** — SQL entry area for manual queries

## Tips for first-time users

* Start with **Query data from table** to confirm the connection works.
* Use a simple reporting table first.
* If you are not sure what to write, use **Use AI** before manual SQL.
* Check the **Result** tab after each test run.

{% hint style="info" %}
If you are unsure which table or fields to use, ask your database owner or technical team first.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.diaflow.io/workflow-builder/nodes/database/snowflake.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.