Skip to main content

Google BigQuery

Setup instructions​

Follow the instructions below to grant Rill access to your Google BigQuery datasets.

  1. Find your Google Cloud Service Account by logging into Rill and clicking on Integrations. Your Google Cloud Service Account will be displayed. It will be of the form organization-workspace name>@rilldata.iam.gserviceaccount.com.

  2. Go to your Google Cloud Console and select the project to which you want to grant access.

  3. Open the sidebar menu by clicking the 3 lines button in the top left, then choose IAM & Admin then click on IAM https://console.cloud.google.com/iam-admin/iam

  4. In the IAM menu click the ADD button. This will display a form where you can input the service accounts that can access your project and the permissions with which they can access it.

  5. In the New members field, enter your google service account, found in step 1.

  6. Select the role BigQuery Data Viewer, BigQuery Read Session User, and BigQuery Job User. This will permit Rill to fetch your projects tables into BigQuery.

  1. Click on save.