# BigQuery

You can create your BigQuery connection from either your team's dashboard or directly inside a spreadsheet. From the **Dashboard**, navigate to the **Connections** menu item. Or from inside a spreadsheet, press `/` and then Manage connections. 

## Connection details 

To connect to your BigQuery database, you'll need to enter the parameters in the **Team connections** modal: 

<figure><img src="https://2438361843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff1Y5UzPF2x1oIzVJbUK8%2Fuploads%2F6JJcofnYHiHeEh9Rq7zn%2FCleanShot%202025-07-22%20at%2016.11.48%402x.png?alt=media&#x26;token=bc6db113-1c54-4510-819d-f3f679e8160f" alt=""><figcaption></figcaption></figure>

### Connection name

You can name this whatever you'd like. This is the name you'll see in Quadratic any time you use the connection.&#x20;

### Project ID

This can be found in the project selector at the top of our Google Cloud Console. Do not mistake the project name for the ID; they can be the same but are often different. Make sure you select the ID from the list.&#x20;

<figure><img src="https://2438361843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff1Y5UzPF2x1oIzVJbUK8%2Fuploads%2FWjsziehc9fv66HtRcW3H%2FCleanShot%202025-07-22%20at%2015.53.54%402x.png?alt=media&#x26;token=bb32e9da-b6cd-4cad-aa1d-1ab43c4b912f" alt=""><figcaption></figcaption></figure>

### Dataset&#x20;

Datasets can be found inside your BigQuery instance in the sidebar.&#x20;

<figure><img src="https://2438361843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff1Y5UzPF2x1oIzVJbUK8%2Fuploads%2FlipXyfgA5ZAnIwdzQO3F%2FCleanShot%202025-07-22%20at%2016.09.09%402x.png?alt=media&#x26;token=0089cc01-1904-452e-8bd9-6d38174fdff8" alt=""><figcaption></figcaption></figure>

### Service account configuration

Acquire your service account JSON key from the keys section under service accounts in Google Cloud Console.&#x20;

<figure><img src="https://2438361843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff1Y5UzPF2x1oIzVJbUK8%2Fuploads%2FGO1h8DbMqiPX1t8q6wT9%2FCleanShot%202025-07-22%20at%2016.10.39%402x.png?alt=media&#x26;token=c44b5671-8033-45cd-a9fa-559caff2f45b" alt=""><figcaption></figcaption></figure>

### IP allow-list

{% hint style="info" %}
You may need to whitelist both Quadratic IP addresses to make connections, which are:\
**44.240.255.40** \
**54.68.134.35**

*\* These IP addresses do not apply to self-hosted instances*&#x20;
{% endhint %}

If you need help setting up your data sources, [contact us](https://quadratichq.com/contact). Some extra resources and instructions vary depending on where your database lives.&#x20;