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

# Snowflake

<Card title="Strong Security" icon="shield-check" iconType="sharp-solid" color="#49DE80">
  Brewit never has access to your database credentials. All credentials are
  encrypted and stored in AWS Secret Manager.
</Card>

## Connect your Snowflake database

<Steps>
  <Step title="Create">
    Create Snowflake connection
    [here](https://app.brewit.ai/resources/new/snowflake)
  </Step>

  <Step title="Configure">
    Snowflake data warehouse credentials: [Account
    identifier](/docs/integrations/databases/snowflake#faq), Database name, User
    role, Database warehouse (optional), Database schema (optional), username,
    password
  </Step>

  <Step title="Test the connection">
    Click **Test Connection** button to verify that Brewit can successfully
    connect to Snowflake. If the test fails, check the data source settings and
    try again.
  </Step>

  <Step title="Save the resource">
    Click **Create** button to complete the setup. Now you can start chatting
    with Brewit's BI agent to analyze your data.
  </Step>
</Steps>

### FAQ

<Accordion title="Where can I get the account identifier?">
  Copy the account URL from your Snowflake account.
  The account URL looks something like `https://<account_identifier>.snowflakecomputing.com`
  Then, you can get account\_identifier from the url
</Accordion>

## Whitelist Brewit's IP addresses

If the data source is behind a firewall or restricts access based on IP address, then you must ensure that Brewit can access it.
If necessary, configure your data source to allow access from Brewit's IP addresses.

Allow Brewit to read into your Microsoft SQL Server using the following IP addresses:

```
18.235.135.168
34.194.74.33
```