# 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: 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.roadwayai.com/implement-roadway/warehouse-native/connect-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.