> ## Documentation Index
> Fetch the complete documentation index at: https://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

<Steps>
  <Step title="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)
  </Step>

  <Step title="Go to Settings">
    Navigate to **Settings > Integrations** in Adapt
  </Step>

  <Step title="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                |
  </Step>

  <Step title="Test the connection">
    Ask Adapt to query your Snowflake data
  </Step>
</Steps>

<Note>
  For key pair authentication, use `SNOWFLAKE_PRIVATE_KEY` instead of `SNOWFLAKE_PASSWORD`.
</Note>

### 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
```