BigQuery
Prerequisites
Setup
Before you begin, you need to make sure you have already done the following in your Google Cloud:
Create a service account for BigQuery.
Grant BigQuery permission to this service account. The least permission required is
BigQuery Data Viewer
. You might also need other permissions likeBigQuery Job User
depending on the query to run.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