Skip to main content

BigQuery

Overview

To set up connection with BigQuery, we need the following:

  • Granting Permissions to a Statsig-owned Service Account
  • Your BigQuery Project ID

Start by enabling the BigQuery source under Metrics -> Ingestion -> Add Source.

Grant Permissions to Statsig's Service Account

You need to grant some permissions for Statsig from your Google Cloud console in order for us to access your BigQuery data.

  1. In your BigQuery's IAM & Admin settings, add the Statsig service account you copied in the Statsig Console as a new principal for your project, and give it the following roles:
    • BigQuery User

image


  1. Navigate to your BigQuery SQL Workspace, choose the dataset, click on "+ Sharing" -> "Permissions" -> "Add Principal" to give the same Statsig service account "BigQuery Data Viewer" role on the dataset.

    image

Now the service account should have the required permissions to export data from this dataset.

BigQuery Project ID

Find your BigQuery Project ID below

  1. Click on your Project Dropdown inside your Cloud Console.

Frame 4

  1. Copy and paste relevant Project ID from the modal pop-up.

Frame 5