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

© 2024 Infinite Canvas Inc.
Twitter logo
LinkedIn logo
Spotify logo