BigQuery Set up
Overview
To set up a connection with BigQuery, we need the following steps:
- Grant Permissions to an ABC Service Account
- Your BigQuery Project ID
- The data location of your BigQuery Project
Start by enabling the BigQuery source in your project settings.
Grant Permissions to ABC's Service Account
You need to grant some permissions for ABC from your Google Cloud console for us to access your BigQuery data.
(1)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:
(2)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.
(3)Now the service account should have the required permissions to run queries .
BigQuery Project ID
Find your BigQuery Project ID below Click on your Project Dropdown inside your Cloud Console:
Data Location
Find Data location below