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

# Connecting Snowflake to your app

> Connect Base44 to your Snowflake data warehouse to query data and build analytics apps.

Connect your Base44 app to Snowflake to query your data warehouse and build dashboards, reports, and analytics apps on top of your warehouse data.

<Tip>
  **Snowflake is a connector for app builders.** You connect it once with your own Snowflake credentials at the workspace level, and your app queries the warehouse through that connection. Each person using your app does not connect Snowflake themselves.
</Tip>

<Note>
  You need a [**Builder plan**](https://base44.com/pricing) or higher to use connectors in your app.
</Note>

***

## What you can do

<CardGroup cols={3}>
  <Card title="Query warehouse data" icon="database">
    Run SQL against your Snowflake warehouse and surface the results in your app.
  </Card>

  <Card title="Build analytics dashboards" icon="chart-column">
    Turn warehouse queries into charts, tables, and dashboards your team can read.
  </Card>

  <Card title="Trigger on data changes" icon="bell">
    Combine Snowflake with other connectors, for example alert a Slack channel when a metric drops.
  </Card>
</CardGroup>

**Example prompts for the AI chat**

```text theme={null}
Query Snowflake to show sales trends by region and display them as a dashboard.
```

```text theme={null}
Build a report from my Snowflake warehouse that summarizes revenue by product line.
```

***

## At a glance

<Card>
  <div className="b44-spec">
    <div className="b44-spec-row"><div className="b44-spec-key">Type identifier</div><div className="b44-spec-val"><code>snowflake</code></div></div>
    <div className="b44-spec-row"><div className="b44-spec-key">Auth model</div><div className="b44-spec-val">OAuth, bring your own credentials</div></div>
    <div className="b44-spec-row"><div className="b44-spec-key">Connector type</div><div className="b44-spec-val">For app builders (workspace-level)</div></div>
    <div className="b44-spec-row"><div className="b44-spec-key">Connection config</div><div className="b44-spec-val"><code>subdomain</code> (your Snowflake account identifier), required</div></div>
  </div>
</Card>

***

## Connect it

Snowflake is a connector for app builders, so you connect it once at the workspace level with your own warehouse credentials.

<Check>
  Before you begin, you need:

  * A **Snowflake OAuth security integration** in your Snowflake account, so you have a **Client ID** and **Client Secret**.
  * Your Snowflake **account identifier** (the `subdomain`, for example `xy12345.us-east-1`).
  * Credentials authorized to query the databases you want to use.
</Check>

**To add Snowflake from your workspace settings:**

1. Click your workspace name at the top left.
2. Click **Settings**.
3. Under **Integrations** in the left sidebar, click **Connectors**.
4. Under **Connectors For App Builders**, find **Snowflake**.
5. Click **Add** next to the connector.
6. Click **View redirect URIs**, then add the redirect URI shown in Base44 to your Snowflake OAuth integration: `https://app.base44.com/api/external-auth/callback`
7. Enter the **Client ID**, **Client Secret**, and the **Scopes** your app needs.
8. Enter your **Snowflake Account** identifier.
9. Click **Add Connector**.

<Note>
  Your Snowflake Account is your account identifier, for example `xy12345.us-east-1`. Do not include `.snowflakecomputing.com`.
</Note>

You can also set up Snowflake from the AI chat in an app. Describe what you want to build, and when prompted, provide the same connector details. The connector is registered at the workspace level and becomes available across all apps in that workspace.

***

## Use it in a backend function

Once Snowflake is connected, your backend functions can retrieve an access token and query your warehouse. Base44 handles the OAuth flow and credential storage.

```javascript theme={null}
const connection = await base44.asServiceRole.connectors.getConnection("snowflake");
// Use the connection's access token to call the Snowflake SQL API.
```

This is a simplified example. For the full pattern, including how to read the connection details and structure the request, see the developer documentation:

<CardGroup cols={1}>
  <Card title="Connectors (developer docs)" icon="code" href="/developers/backend/resources/connectors">
    Retrieve a connection, read its details, and call the service API from a backend function.
  </Card>
</CardGroup>

***

## Troubleshooting

<AccordionGroup>
  <Accordion title="I do not see Snowflake in workspace settings">
    Confirm that you are working in the correct workspace and that you have permission to manage workspace connectors. If you still do not see Snowflake, [contact support](/Community-and-support/Contacting-support).
  </Accordion>

  <Accordion title="My Snowflake Account is not accepted">
    Enter only your Snowflake account identifier, for example `xy12345.us-east-1`. Do not include `.snowflakecomputing.com`.
  </Accordion>

  <Accordion title="The connection does not work after setup">
    Check that the redirect URIs shown in Base44 are added to your Snowflake OAuth integration. Then confirm that the Client ID, Client Secret, Scopes, and Snowflake Account are correct.
  </Accordion>
</AccordionGroup>

***

## FAQs

<AccordionGroup>
  <Accordion title="Who can add the Snowflake connector?">
    You need permission to manage workspace connectors.
  </Accordion>

  <Accordion title="Where do I find the Base44 redirect URIs?">
    Click **View redirect URIs** in the connector setup form. Add the redirect URIs shown in Base44 to your Snowflake OAuth integration.
  </Accordion>

  <Accordion title="What should I enter for Snowflake Account?">
    Enter your Snowflake account identifier, for example `xy12345.us-east-1`. Do not include `.snowflakecomputing.com`.
  </Accordion>

  <Accordion title="Can I add Snowflake from the AI chat?">
    Yes. You can start from the AI chat in a specific app. If the connector is not set up yet, Base44 asks for the connector details before continuing.
  </Accordion>

  <Accordion title="Do people using my app need to connect Snowflake themselves?">
    No. The Snowflake connector is set up once at the workspace level and can be used across apps in that workspace.
  </Accordion>
</AccordionGroup>