> ## Documentation Index
> Fetch the complete documentation index at: https://v1-docs.adapt.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake

> Connect Snowflake to query your data warehouse with natural language

Connect Adapt to Snowflake to query your data warehouse using natural language. Adapt can write and execute SQL queries against your Snowflake tables.

## Setup

**1. Get your Snowflake credentials**

You'll need:

* Account identifier (e.g., `abc12345.us-east-1`)
* Warehouse name
* Database and schema
* Username and password (or key pair)

**2. Go to Settings**

Navigate to **Settings > Integrations** in Adapt

**3. Add secrets**

Add the following secrets:

| Secret Name | Value |
| - | - |
| `SNOWFLAKE_ACCOUNT` | Your account identifier |
| `SNOWFLAKE_WAREHOUSE` | Warehouse name |
| `SNOWFLAKE_DATABASE` | Database name |
| `SNOWFLAKE_SCHEMA` | Schema name |
| `SNOWFLAKE_USER` | Username |
| `SNOWFLAKE_PASSWORD` | Password |

**4. Test the connection**

Ask Adapt to query your Snowflake data

> [!NOTE]
>
> For key pair authentication, use `SNOWFLAKE_PRIVATE_KEY` instead of `SNOWFLAKE_PASSWORD`.

### Security

* Credentials are encrypted at rest with AES-256
* We recommend using a read-only Snowflake user
* Consider using a dedicated warehouse for Adapt queries
* All queries are logged for audit purposes

## Capabilities

Adapt can query your Snowflake data warehouse. Run SQL queries using natural
language to analyze your data.

### Examples

Explore data:

```
What tables are available in Snowflake?
```

Query data:

```
Show me the top 10 customers by revenue from the sales table
```

Analyze trends:

```
Analyze trends in the orders table over the past year
```

Generate reports:

```
Create a summary of our key metrics from Snowflake
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.