BigQuery

How BigQuery ingestion works

To set up a connection with BigQuery, you need to:

• Grant permissions to a Statsig-owned service account
• Provide your BigQuery Project ID

Enable the BigQuery source under Metrics > Ingestion > Add Source.

Grant permissions to Statsig's service account

Grant the following permissions from your Google Cloud console to allow Statsig 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

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

   

The service account now has the required permissions to export data from this dataset.

Find your BigQuery Project ID

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

2. Copy the relevant Project ID from the modal.