# 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="/files/08zuiaq0dWRhABCyYxqm" 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="/files/7PRRl6PiX4jWKuOS6O7D" alt=""><figcaption></figcaption></figure>

### Dataset&#x20;

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

<figure><img src="/files/7xhMAFYiVGArflrOClfj" 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="/files/sCu7ogCO3yXvHqTn8wrX" 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;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.quadratichq.com/connections/bigquery.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.