# Snowflake
The **Snowflake Node** allows you to interact with a Snowflake database—either by querying data or inserting new records.
***
### Connecting to Snowflake — API Key
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:
| Field | Value |
| -------------------------- | ------------------------------------------------ |
| **Connection Name** | This is whatever you want to name the connection |
| **User** | Your chosen Snowflake account username |
| **Password (Optional)** | Your chosen Snowflake account password |
| **Private Key (Optional)** | Only if using key-pair authentication |
| **Account** | `nqxzcwd-ab12345` (see where to find below) |
| **Warehouse** | `DUMMY_WAREHOUSE` (see where to find below) |
| **Role** | `ACCOUNTADMIN` (see where to find below) |
| **Database** | `DUMMY_DB` (see where to find below) |
| **Schema** | `DUMMY_SCHEMA` (see where to find below) |
{% hint style="info" %}
**Note**: You need to enter at least one of the two optional fields
{% endhint %}
### 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:
### Connecting to Snowflake — OAuth2
For your organization's users to connect to Snowflake using OAuth2, you must first create an OAuth2 App inside Snowflake. Once this app is created, users can use it to sign-into Snowflake via OAuth2 in third-party applications.
To create the OAuth2 App, first have someone with the ACCOUNTADMIN role run the following script in Snowflake:
```sql
CREATE OR REPLACE SECURITY INTEGRATION STACKAI_OAUTH_APP
TYPE = OAUTH
ENABLED = TRUE
OAUTH_CLIENT = CUSTOM
OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
OAUTH_REDIRECT_URI = 'https://www.stackai.com/auth'
OAUTH_ISSUE_REFRESH_TOKENS = TRUE
OAUTH_REFRESH_TOKEN_VALIDITY = 7776000 -- ~90 days
BLOCKED_ROLES_LIST = ('SYSADMIN'); -- optional: prevent high-privilege roles
;
```
Once the integration has been created, run the following to get a `client_id` and `client_secret`:
```sql
SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('STACKAI_OAUTH_APP');
```
Store this information as you will need it to make an OAuth2 connection.
#### Creating a custom OAuth connector
To use your personal Snowflake OAuth client in StackAI, you need to first create a custom connector in **Settings -> Connectors**. Here, select **+ New Connector.**
Select **Snowflake (OAuth2)** and **Create Connector**.
Once you've created a new connector, it will be in draft until you add the required fields. Edit the Connector and add the client ID and client secret from Snowflake.
You have the option of setting custom scopes for your connector. If you'd like the connections your users make to always use a specific Snowflake role, replace the placeholder `session:role:PUBLIC` scope with `session:role:{YOUR_ROLE}`. If you'd like your connection to inherit the user's default role, you can just delete this placeholder scope.
Make sure the required fields are filled in, then hit **Save**.
#### Creating a connection with your Connector
When entering the new connection dialog, select Snowflake, then select the Connector you created. You should be redirected to sign in to Snowflake.
### 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:
```
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:
```
{
"name": "John Doe",
"email": "john@example.com",
"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
| Action Name | Description | Key Inputs | Key Outputs |
| -------------------------- | ------------------------------- | ------------------ | ----------------------------------- |
| Query Snowflake Database | Run queries and get results | sql\_schema, query | sql\_query, results |
| Insert Data into Snowflake | Insert new records into a table | table\_name, data | sql\_query, rows\_affected, success |
