Skip to content
DataSquaresDocs

BigQuery

BigQuery is generally available in the DataSquares connection wizard. Connect with a GCP project and a service-account key.

  1. In DataSquares, open Data Sources and choose Add data source.

  2. Pick BigQuery in the connector picker (search or browse by category).

  3. Fill in the connection details below, then test the connection and save.

Connection details

Section titled “Connection details”
Field What to enter
Project ID The Google Cloud project that holds your datasets.
Service-account key Paste the JSON key of a service account with BigQuery Data Viewer and BigQuery Job User roles.

Create the service account

Section titled “Create the service account”
  1. In Google Cloud Console → IAM & Admin → Service Accounts, create one (e.g. datasquares-reader).
  2. Grant it two roles on the project: BigQuery Data Viewer and BigQuery Job User (viewing data isn’t enough — running queries needs Job User).
  3. Create a JSON key for the account and paste its contents into the connection form.

To scope tighter than the whole project, grant Data Viewer on specific datasets instead (dataset → Sharing → Permissions).

Common errors

Section titled “Common errors”
Error Cause / fix
Access Denied: BigQuery BigQuery: Permission denied missing Job User on the project or Data Viewer on the dataset
Not found: Dataset the dataset lives in another project or region than expected — check the project ID in the form
invalid key errors the pasted JSON must be the entire key file, unmodified
Section titled “Related”
© 2026 DataSquares