Skip to content

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: image.pngimage.png

(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. image.png

(3)Now the service account should have the required permissions to run queries .

BigQuery Project ID

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

Data Location

Find Data location below image.png