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】
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.
How to find BigQuery Project ID
Find your BigQuery Project ID below Click on your Project Dropdown inside your Cloud Console:
How to find Data Location
Find Data location below