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

# BigQuery

## Intro

Find out more about BigQuery [here](https://cloud.google.com/bigquery).

## Necessary Credentials

* **Project ID**

  * This is the ID of the project

* **JSON Key File**

  * This file was given to you when you created the service account

## Allowlisting Explo's IPs

<Note>
  You may need to allowlist egress IPs for your
  [Connectivity Region](/data-sources/connecting-to-data-sources/connectivity-regions).
</Note>

## BigQuery Credentials

Create a Bigquery service user

1. In the Cloud Console, go to the **Create service account key**
   [page](https://console.cloud.google.com/apis/credentials/serviceaccountkey).

2. From the **Service account** list, select **New service account**.

3. In the **Service account name** field, enter a name.

4. From the **Role** list, add the following roles

   1. BigQuery Job User
   2. BigQuery Data Viewer
   3. BigQuery Metadata Viewer

5. Click **Create**. A JSON file that contains your key downloads to your
   computer.

<Note>
  The **Role** field affects which resources your service account can access in
  your project. You can revoke these roles or grant additional roles later. For
  more information, see
  [Granting, changing, and revoking access to resources](https://cloud.google.com/iam/docs/granting-changing-revoking-access).
</Note>

## Troubleshooting

1. If you are getting `403 Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.`

Check out [this response](https://www.googlecloudcommunity.com/gc/Data-Analytics/Access-Denied-BigQuery-BigQuery-Permission-denied-while-getting/m-p/545009/highlight/true#M1699) from Google's support team. This has solved previous issues!

## Questions?

Please reach out to the Explo team at
[support@explo.co](mailto:support@explo.co) if you have any questions.