> For the complete documentation index, see [llms.txt](https://canvasapp.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://canvasapp.gitbook.io/docs/getting-started/connecting-your-data/bigquery-beta.md).

# BigQuery

Connect your BigQuery warehouse to explore and visualize your data

Connecting to BigQuery requires creating a [Service account](https://cloud.google.com/iam/docs/service-accounts) 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](/docs/security/data-security.md).

We recommend creating a separate service account with just the required roles following the principle of least privilege. 

Login to your [Google Cloud Console](https://console.cloud.google.com/). 

Open the Burger Menu on the side and Go to IAM -> Service Accounts

![](https://3313014851-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fy7E9BPGuy0SmG7YF1yur%2Fuploads%2FqY9c3o1m3L5pOQlEYvyO%2FScreen%20Shot%202022-02-08%20at%202.46.35%20PM.png?alt=media\&token=e955fbea-6013-4b8f-a427-0337f2f0c72f)

Click `Create Service Account`

Fill out the form and click `Create`

![](https://3313014851-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fy7E9BPGuy0SmG7YF1yur%2Fuploads%2FYptvBUHfZNG3WEiraQPk%2FScreen%20Shot%202022-02-08%20at%202.49.00%20PM.png?alt=media\&token=16b96f72-d08c-419a-aed7-6975c30fd633)

On the following page, grant at least the roles BigQuery Data Owner and BigQuery Job User

![](https://3313014851-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fy7E9BPGuy0SmG7YF1yur%2Fuploads%2FIFtlM59gGRPP1I7E8X3K%2FScreen%20Shot%202022-02-08%20at%202.50.14%20PM.png?alt=media\&token=780757b6-5d41-4a8b-8868-9161507ca6fa)

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`

![](https://3313014851-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fy7E9BPGuy0SmG7YF1yur%2Fuploads%2FycOZbtLp45SpfnMIa634%2FScreen%20Shot%202022-02-08%20at%202.50.54%20PM.png?alt=media\&token=089c3ec8-0443-4ea1-b14e-33d6e370814c)

Select `JSON`

Click `Create` - your JSON key should download automatically

Upload this key to Canvas on the page shown below

![](https://3313014851-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fy7E9BPGuy0SmG7YF1yur%2Fuploads%2Fklgf6l7evAfDClInphWA%2FScreen%20Shot%202022-02-05%20at%208.01.35%20PM.png?alt=media\&token=74953069-9bf9-4e2e-a3d5-79b6fbde57dd)