Requirements
The BigQuery project must have a Service Account with the jobs.create permission (such as the BigQuery.User role) in order to run queries, and have access to view the dataset you'd like to connect to (such as the BigQuery.dataViewer role).
Service Accounts can be created in the Google Cloud Console here: https://console.cloud.google.com/iam-admin/serviceaccounts
To connect with this Service Account you'll need a Private Key
.jsonfile associated with the Service AccountOnce a Service Account is created, a key can be created in the Keys tab for that account.
The key will be downloaded immediately and only once. If you lose the key you can always create a new one.
Step 1 - Connect
To connect to your BigQuery instance you simply need to upload the
.jsonfile containing the credentials for your Service Account.If you need to rotate or pick new credentials after connecting you can replace your existing credentials by uploading a new file.
