Before you begin, you need to make sure you have already done the following in your Google Cloud:

  1. Grant BigQuery permission to this service account. The least permission required is BigQuery Data Viewer. You might also need other permissions like BigQuery Job User depending on the query to run.

  2. Create a service account key of your service account.

Then you can create your BigQuery data source using your service account key.

First, you need to specify your BigQuery project ID and upload your service account key into JSON Key File. If you want to preview the dataset schema in query source page, you need to check Load Schema option. If your dataset is outside of the US, you need to specify the Processing Location , eg. europe-west1. You can find your region name to use from this document.

Last updated