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

# Snowflake Agent Connector

> Connect your Agent to Snowflake to query your data warehouse directly from conversations.

The Snowflake Connector lets your [Agents](/agents/overview) query your data warehouse and retrieve results during conversations. Ask questions about your data in plain language and get answers grounded in your Snowflake tables. Data is accessed in real time and never copied or stored in Cassidy.

<Tip>For best results with complex Connector queries, use a powerful, reasoning-capable model. Cassidy supports models from OpenAI, Anthropic, and Google — see [Choose the right AI model](/guides/choose-ai-model) for current recommendations.</Tip>

## Set up the Snowflake Connector

<Steps>
  <Step title="Navigate to your Agent">
    Go to **Agents** and select the Agent you want to configure.

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-0.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=143636f2c1fb2f14e9d5f531ebc4bc69" alt="Agents page with list of available Agents" width="573" height="332" data-path="images/integrations/snowflake-tool-img-0.png" />
    </Frame>
  </Step>

  <Step title="Open the Connectors section">
    Click the **Setup** tab and scroll to the **Connectors** section.

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-1.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=4df7f9a51d1273feca7428463de04f1f" alt="Agent Setup tab showing the Connectors section" width="2826" height="790" data-path="images/integrations/snowflake-tool-img-1.png" />
    </Frame>
  </Step>

  <Step title="Add the Snowflake Connector">
    Click **+ Add Connector** and select **Snowflake**.

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-2.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=9c9ed7a6effbee77e3cf844e25155e0e" alt="Connector picker with Snowflake option" width="1970" height="1224" data-path="images/integrations/snowflake-tool-img-2.png" />
    </Frame>
  </Step>

  <Step title="Choose a connection method">
    Select how users will authenticate:

    * **Each user connects their own account** (recommended) — each user signs in with their own Snowflake credentials
    * **Use a shared connection** — all users access Snowflake through one shared account

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-3.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=b6033eb16e292523fd192f97c07ab349" alt="Connection method selection for Snowflake" width="624" height="378" data-path="images/integrations/snowflake-tool-img-3.png" />
    </Frame>
  </Step>

  <Step title="Set up the connection">
    If using a shared connection, enter your Snowflake **account identifier** and authenticate.

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-4.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=c3f3202c8ab3ee4fb4f2e6260bd0c85e" alt="Snowflake account identifier input field" width="607" height="109" data-path="images/integrations/snowflake-tool-img-4.png" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-5.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=c98ac4f96c4c54d61683d4f60a0b365e" alt="Snowflake authentication flow" width="592" height="706" data-path="images/integrations/snowflake-tool-img-5.png" />
    </Frame>

    Optionally share the connection with other team members.

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-6.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=716b05987a830291db41a9e7602c952e" alt="Connection sharing options for team members" width="1352" height="1198" data-path="images/integrations/snowflake-tool-img-6.png" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-7.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=cbd80f7c7e4bd562e375da3e1b7eb181" alt="Sharing permissions configuration" width="1872" height="404" data-path="images/integrations/snowflake-tool-img-7.png" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-8.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=c8df63c05ec7ea9636a4bcfd441dbffb" alt="Shared connection configured and ready" width="624" height="192" data-path="images/integrations/snowflake-tool-img-8.png" />
    </Frame>

    <Tip>To find your account identifier: in your Snowflake web interface, click your account button in the bottom left corner, then select **Account** → **View Account Details**. Copy the **Account identifier**, which is in the format `ABCDEFG-XYZ12345`.</Tip>
  </Step>

  <Step title="Configure tool permissions">
    Set permissions for each action the Agent can perform:

    * **Always Allow** — The Agent runs the action automatically when needed
    * **Needs Approval** — The Agent asks for permission before running the action
    * **Disabled** — The Agent cannot perform the action

    Common Snowflake tools include actions for viewing metadata and querying data — such as Describe Table, Explore Columns, Show Databases, Show Schemas, Show Tables, and Run Read Query — as well as Run Write Query for modifying data. You decide the permission level for each tool separately. For example, you might set Show Databases and Run Read Query to **Always Allow** but Run Write Query to **Disabled**.

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-9.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=e7c83a45f356bda08c7d5e61c2cd4d13" alt="Tool permission settings for Snowflake actions" width="489" height="437" data-path="images/integrations/snowflake-tool-img-9.png" />
    </Frame>

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-10.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=c36fc5fc6115846284809e382677b25a" alt="Permission options: Always Allow, Needs Approval, Disabled" width="624" height="423" data-path="images/integrations/snowflake-tool-img-10.png" />
    </Frame>
  </Step>

  <Step title="Enable the Connector">
    Click **Add** to enable the Connector for this Agent.

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-11.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=3bb772ff3b81cfde4500d1dee686f962" alt="Add button to enable the Snowflake Connector" width="624" height="288" data-path="images/integrations/snowflake-tool-img-11.png" />
    </Frame>
  </Step>

  <Step title="Start a conversation">
    Navigate to **Chat** and select the Agent with the Snowflake Connector enabled.

    If you chose **Each user connects their own account**, users are prompted to connect their Snowflake account from within the chat the first time they use the Connector.

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-12.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=432e4b6d0f582e372b9cc4396a7b8090" alt="Chat with the Snowflake-enabled Agent showing connection prompt" width="624" height="424" data-path="images/integrations/snowflake-tool-img-12.png" />
    </Frame>

    Once connected, your Agent can query your Snowflake database to retrieve data, run analytics, and answer questions about your data warehouse.

    <Frame>
      <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-13.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=347bb96884b2a3153fe3039295f9b0c5" alt="Agent responding with Snowflake query results in the conversation" width="624" height="476" data-path="images/integrations/snowflake-tool-img-13.png" />
    </Frame>
  </Step>
</Steps>

## Monitor Snowflake actions

When an Agent uses the Snowflake Connector during a conversation, you can review what happened by expanding the **Analyzed Sources** dropdown and clicking any Snowflake step.

<Frame>
  <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-14.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=69c5b158b0a0787abfe259fe24b1f791" alt="Analyzed Sources dropdown showing Snowflake actions taken during the conversation" width="624" height="210" data-path="images/integrations/snowflake-tool-img-14.png" />
</Frame>

<Frame>
  <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-15.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=76e5d4195cd0ca0c9749606c1818210d" alt="Expanded Snowflake action details showing the query and results" width="624" height="485" data-path="images/integrations/snowflake-tool-img-15.png" />
</Frame>

If an action requires approval (set to **Needs Approval**), you see an approval prompt where you can click **Approve** or **Reject** before the action executes.

<Frame>
  <img src="https://mintcdn.com/cassidy/jL2NfbhR1omEZxnz/images/integrations/snowflake-tool-img-16.png?fit=max&auto=format&n=jL2NfbhR1omEZxnz&q=85&s=5bee3fdc64e6b783c04bbc854192716b" alt="Approval prompt with Approve and Reject buttons for a Snowflake action" width="1002" height="558" data-path="images/integrations/snowflake-tool-img-16.png" />
</Frame>

## Data security

Snowflake data is accessed in real time and is not copied or stored in Cassidy. The Agent only queries Snowflake when needed to answer a question or complete a task.

<Accordion title="OAuth scopes">
  The Snowflake Connector requests access to run queries on the databases and schemas you authorize. Cassidy does not access data outside the scope you explicitly grant.
</Accordion>

## Next steps

<CardGroup cols={2}>
  <Card title="Connectors overview" icon="plug" href="/agents/connectors/overview">
    Learn about all available Agent Connectors and how they work.
  </Card>

  <Card title="Analyze data with an Agent" icon="chart-mixed" href="/guides/analyze-data-with-agent">
    Combine Snowflake data with Code Execution & File Creation for deeper insights.
  </Card>
</CardGroup>
