> For the complete documentation index, see [llms.txt](https://docs.roadwayai.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roadwayai.com/implement-roadway/warehouse-native/connect-bigquery.md).

# Connect BigQuery

### Connect Roadway to BigQuery

[Data Warehouse Requirements](/data-requirements/warehouse-requirements.md)

We have set up our service account in our Google Cloud project for you to connect to. Your company specific service account email will be provided by Roadway directly.

1. Go to the **Google Cloud Console** and select your project.
2. Navigate to **IAM & Admin > IAM**.
3. Click **Add**.
4. In the **New Members** field, enter the service email provided to you by Roadway
   1. **Assign the following roles:**
      * **BigQuery Data Viewer** – for read-only access to your BigQuery data.
      * **BigQuery Job User** – to allow for query execution.
   2. Click **Save** to apply the changes.
5. Using your own appropriately permissioned account, create a `roadway` dataset in your BigQuery project. For the above service email provided by Roadway, grant the following roles *on this dataset*:
6. Assign the following roles:
   * **BigQuery Data Editor** - for read and write permissions on this dataset
   * **BigQuery Job User** - to allow for query execution (this may be inherited via step 4a above)
7. Click **Save** to apply the changes.

**‍‍**

**Access Management**

Once access is granted, send us the project ID of the datasets you granted us permission to in Slack. Once received, we will securely connect to your BigQuery warehouse.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.roadwayai.com/implement-roadway/warehouse-native/connect-bigquery.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.