Connect Roadway to BigQuery

Data Warehouse Setup

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.