Connect BigQuery so Coworker can query your warehouse data on request. BigQuery is admin-connected with a Google service account.
What Coworker can do with BigQuery
Run read queries against the datasets in the connected GCP project
Answer analytics questions using warehouse tables alongside your other connected data
Before you start
You must be a Coworker Network Admin
You need a Google Cloud service account with IAM roles on the target project and datasets
You need the service account JSON key and the GCP project ID
Connect as an admin
Open Data Sources from the admin settings in Coworker.
Select Google BigQuery.
Paste the service account JSON and enter the project ID.
Save.
Connect as a member
Where individual BigQuery OAuth is enabled for your workspace, members can connect their own Google account from Work page > Data Sources so queries run under their own permissions. Otherwise BigQuery runs entirely on the admin service account.
Good to know
The service account JSON is a long-lived secret — treat and rotate it accordingly.
A credential can authenticate successfully but see no tables if the project ID or dataset-level grants do not match.
BigQuery content is not indexed into Organizational Memory; it is available for querying.