Google BigQuery

This is a step-by-step tutorial on how to connect, read and write to your BigQuery data warehouse using Deepnote

General information

Step by step tutorial

  1. Follow this guide to create a service account and download its key

Make sure to enable BigQuery API for your GCP project.

Make sure the service account has sufficient permissions for the resources you want to use. If the authorization process fails, we recommend visiting BigQuery's access control page.

2. Create BigQuery integration & paste the content of your service account key to the specified field

Your service account key will be encrypted and stored in our database. The JSON file will be mounted to every project the integration is connected to, so the python library can easily access it.

3. After the integration is created, you can connect it to any of your projects. Go through our How to use tutorial in order to successfully connect to your BigQuery warehouse.

Take into account that BigQuery integration does not support Application Default Credentials (ADC) by default. If you would like to use ADC or use one service account for multiple Google services, consider creating a GCP integration.