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

# Snowflake

> Turn your Snowflake data into answers — query and explore your warehouse in plain English

Your agent can explore your Snowflake databases and run read-only queries so you get insights, reports, and data checks without writing SQL. Ask in natural language and get answers. Authentication uses a Snowflake [Programmatic Access Token (PAT)](https://docs.snowflake.com/en/user-guide/programmatic-access-tokens) — no password — and queries time out after 30 seconds.

<Frame>
  <img src="https://mintcdn.com/abundly/OlRjRmIDxi2An2do/images/snowflake-capability.png?fit=max&auto=format&n=OlRjRmIDxi2An2do&q=85&s=74ba3c7893a87e9e56f2a6f208b73815" alt="Screenshot: Snowflake capability card in Settings → Capabilities with account, login name and PAT configured" style={{ width: '400px', height: 'auto' }} width="713" height="1024" data-path="images/snowflake-capability.png" />
</Frame>

## How to enable

Go to **Settings → Capabilities** and enable **Snowflake**, then link a workspace secret containing your **Account Identifier**, **Login Name**, and **Programmatic Access Token (PAT)**. The same secret can be reused across agents and teams.

## Example use cases

* **Revenue and rankings** — "Query our Snowflake sales table and show top 10 customers by revenue this year"
* **Scheduled reports** — "Every Friday, run a query for weekly signups and post a summary to Slack"
* **Data reconciliation** — "Compare yesterday's order count in Snowflake with the count in our CRM and flag any mismatch"
* **Schema discovery** — "List the tables in our analytics schema and describe the columns in the events table"
* **Ad-hoc analysis** — "What were our top-performing campaigns last month by spend and conversions? Use the marketing schema in Snowflake"

<Frame>
  <img src="https://mintcdn.com/abundly/OlRjRmIDxi2An2do/images/snowflake-chat-results.png?fit=max&auto=format&n=OlRjRmIDxi2An2do&q=85&s=1bcae9340374cd9dd0ae9c0dab6d1ca5" alt="Dr Plotts answering a question using Snowflake data" style={{ width: '400px', height: 'auto' }} width="1024" height="495" data-path="images/snowflake-chat-results.png" />
</Frame>

<Frame>
  <img src="https://mintcdn.com/abundly/OlRjRmIDxi2An2do/images/snowflake-chart.png?fit=max&auto=format&n=OlRjRmIDxi2An2do&q=85&s=d7790d670d03d57d276ab0b12ae696e9" alt="Dr Plotts chart from Snowflake data" style={{ width: '400px', height: 'auto' }} width="1024" height="925" data-path="images/snowflake-chart.png" />
</Frame>

<Note>
  The agent supports read-only operations only (e.g. querying data, listing tables, describing schemas). No DDL or DML.
</Note>

## How to connect Snowflake

<Steps>
  <Step title="Get your account identifier and login name">
    In Snowflake, open **Account Details**. Note your **Account Identifier** (format: <code>\<org>-\<account></code>) and **Login Name** (username).
  </Step>

  <Step title="Create a Programmatic Access Token (PAT)">
    Generate a PAT in Snowflake for programmatic access — see [Snowflake's PAT documentation](https://docs.snowflake.com/en/user-guide/programmatic-access-tokens) for how to create one. The PAT is used instead of a password for the integration.
  </Step>

  <Step title="Configure in Abundly">
    Go to **Settings → Capabilities**, enable **Snowflake**, and create a new workspace secret of type **Snowflake**. Paste in the **Account Identifier**, **Login Name**, and **Programmatic Access Token (PAT)**.

    All three values live in a single workspace secret, so you only have to enter them once and can share the same secret across multiple agents.
  </Step>
</Steps>

## Learn more

<CardGroup cols={2}>
  <Card title="BigQuery" icon="database" href="/integrations/bigquery">
    Query and explore your Google BigQuery data from the agent.
  </Card>

  <Card title="Steep" icon="chart-line" href="/integrations/steep">
    Query metrics from your Steep semantic layer without writing SQL.
  </Card>
</CardGroup>