Google BigQuery

Direction integration via Rill's homegrown BigQuery connector

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>@rilldata.iam.gserviceaccount.com.

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

  1. 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
  1. 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.

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

  3. Select the role BigQuery Data Viewer. This will permit Rill to fetch your projects tables into BigQuery.

  1. Click on save.

Did this page help you?