BigQuery
How to connect BigQuery to Count.
Enter your connection details
You'll need:
The Project ID of the BigQuery instance
A service account key in JSON format for a service account with the following permissions
Dataset access
By default, you are able to query any dataset in the BigQuery project (limited by the supplied credentials). You are also able to query datasets in other BigQuery projects (as long as the credentials have access to those projects), but datasets in other BigQuery projects will not appear in the Count UI.
If table access is restricted within a Count project, then canvases in that project will be unable to query tables outside of this BigQuery project.
BigQuery Storage API
If your workspace has been granted an increase in the default query response size limit, you'll need to enable the BigQuery Storage API for this increase to take effect.
Processed data estimations
Troubleshooting
The most common issue when connecting to BigQuery data is getting the service account permissions correct. Double-check the service account permissions with the list above.
Out of Memory Errors:
If you are connecting to a BigQuery project with many tables, you may see an out-of-memory error when you try to connect. To resolve this, you can limit the datasets you want to connect to using the following steps:
Create a new service account with the BigQuery Job User permission
3. Add the service account email to the dataset with the BigQuery Data Viewer permission:
4. Repeat this for any other datasets you want this service account to have access to.
5. Add the service account key to Count and you'll only access the tables for the datasets you've specifically chosen.
Last updated
