Skip to content

BigQuery Connection

To set up a connection with BigQuery, we need the following steps:

  • Please provide your BigQuery project ID and data location.
  • Grant BigQuery User to an ABC Service Account
  • A specified dataset will be used to save temporary tables (assignment tables) and materialized results. Please grant the "BigQuery Data Editor" role on this dataset.
  • Grant the ABC service account "BigQuery Data Viewer" role on any datasets you want the service user to have access to. These datasets could be the data sources for the metrics.

Start by enabling the BigQuery source in your project settings.

Grant BigQuery User to an ABC Service Account

You need to grant some permissions for ABC from your Google Cloud console for us to access your BigQuery data. In your BigQuery's IAM & Admin settings, add the ABC service account you copied in ABC as a new principal for your project, and give it the following roles: 【BigQuery User】 image.png image.png

Grant the "BigQuery Data Editor" role on the dataset

Navigate to your BigQuery Studio, give the "BigQuery Data Editor" role on the dataset you want ABC to use for temporary data. Now the service account should have the required permissions to run queries and materialize results.

Grant "BigQuery Data Viewer" role on any datasets

Navigate to your BigQuery Studio, choose the dataset, click on "+ Sharing" -> "Permissions" -> "Add Principal" to give the same ABC service account "BigQuery Data Viewer" role on a dataset. Do this for any datasets you want the service user to be able to access. image.png

How to find BigQuery Project ID

Find your BigQuery Project ID below image Click on your Project Dropdown inside your Cloud Console: image.png

How to find Data Location

Find Data location below image.png