Bigquery Connection

How BigQuery connection works

To set up a connection with BigQuery, there are two supported methods:

• Grant Permissions to a Statsig-owned Service Account
• Provide Credentials for Your Own First-Party Service Account

In both cases, you need:

• Your BigQuery Project ID
• The dataset Statsig uses to save temporary tables and materialized results

After you choose your method, start by enabling the BigQuery source in your project settings.

Grant permissions to Statsig's service account

Grant Statsig access to your BigQuery data from your Google Cloud console.

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 + Sharing > Permissions > Add Principal, and give the same Statsig service account the "BigQuery Data Viewer" role. Repeat for any datasets you want the service user to access.

   

3. Repeat step 2 to give the "BigQuery Data Editor" role on the dataset Statsig uses for staging data.

The service account has the required permissions to run queries and materialize results.

Using a first-party service account

1. On the BQ service accounts page, click 'Manage Keys' for the service account you want to use

2. Create a new JSON key (which will download a JSON file)

   

   

3. In the Statsig Settings -> Data Connection tab, paste the above key into the Service Account Private Key field under the Advanced toggle.

Additional BigQuery resources

BigQuery project ID

Find your BigQuery Project ID:

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

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

Statsig Customer ID on BigQuery

C01d5f80s

IP addresses Statsig accesses data warehouses from

Additional setup for Warehouse Explorer

Warehouse Explorer lets you find and bring data from any table into Statsig for ad-hoc analysis.