Docs / Connectors

Connect BigQuery

Converise reads experiment data from BigQuery with a service account you control. The key is encrypted at rest and never returned to the browser.

1. Create a read-only service account

1
Create the service account
In the Google Cloud Console open IAM & Admin → Service Accounts and create a service account (or pick an existing one) in the project that holds your experiment data.
2
Grant read-only BigQuery access
Grant the account two roles: BigQuery Data Viewer (read tables) and BigQuery Job User (run queries). Nothing more - Converise only runs SELECT queries.
3
Download a JSON key
On the account's Keys tab choose Add key → Create new key → JSON and download the file.

1
Open the connect form
In your workspace go to Connectors and pick BigQuery from the catalog.
2
Name it and paste the key
Give the connector a name (e.g. Analytics warehouse) and paste the full contents of the downloaded JSON key into the Service-account JSON field.
3
Set up the data source and KPIs
On the connector page point the Data source at the table (or view) that holds outcomes as project.dataset.table - or paste your own SQL, or fill it from a preset (GA4 export on BigQuery). Pick the column roles from the live schema: subject, timestamp, variant, optionally the experiment key, event name and value columns; switch on a separate assignments table when your platform stores exposures apart from outcomes. Then list the KPIs - an event name or a column that counts, reduced per subject as a conversion (count), a quantity (sum) or revenue (sum). Set once; every experiment on this connector binds in three clicks.
4
Schedule per experiment, not here
There is nothing to schedule on the connector. When you bind an experiment, choose whether it refreshes automatically once a day (off by default - each run bills warehouse queries) and at which UTC hour, ideally after your warehouse ETL completes.
5
Check the connection and save
Click Check connection - Converise runs a test query against BigQuery. On Success - the warehouse answered the test query, save the connector.

When editing later, leave the credential field blank to keep the stored key; paste a new key only to rotate it.

Bind an experiment to the connector on its Data sources tab - see Binding evidence.