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

# BigQuery

<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 BigQuery database

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

  <Step title="Configure">
    BigQuery data warehouse credentials: [Service account
    key](https://cloud.google.com/iam/docs/keys-create-delete#creating)
  </Step>

  <Step title="Test the connection">
    Click **Test Connection** button to verify that Brewit can successfully
    connect to BigQuery. 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>

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