Skip to content
DataSquaresDocs
datasquares.aiSign inStart free

Connect DataData Warehouses

BigQuery

You connect BigQuery from the DataSquares connection wizard. Connect with a GCP project and a service-account key.

  1. In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.

  2. Pick BigQuery on that page (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).

Cost control

Section titled “Cost control”
  • Cap per query, GiB billed — optional. BigQuery refuses any query from this source that would bill more than the cap, instead of running it. Leave it empty for no cap.
  • Every query also stops on BigQuery’s side when its time budget runs out, so a cancelled or timed-out request never leaves a job running.

Common errors

Section titled “Common errors”

Test Connection shows a short summary, such as Authentication failed — check the username and password. The text below is what the database itself reports, for example in the SQL editor.

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 Project ID, and set Location to the dataset’s region (for example EU)
invalid key errors the pasted JSON must be the entire key file, unmodified
Section titled “Related”