Connect BigQuery
Connecting to BigQuery requires creating a Service account with sufficient permissions to run jobs and query data, creating a JSON private key for this user, then uploading the key to Canvas. You can read more about how we keep your data safe here.
We recommend creating a separate service account with just the required roles following the principle of least privilege.
Login to your Google Cloud Console.
Open the Burger Menu on the side and Go to IAM -> Service Accounts
Click Create Service Account
Fill out the form and click Create
On the following page, grant at least the roles BigQuery Data Owner and BigQuery Job User
Click done, then select the service account that you just created
On the next page, select the Keys tab
Click Add Key > Create new key
Select JSON
Click Create - your JSON key should download automatically
Upload this key to Canvas on the page shown below
