Skip to main content
Guide to Connect BigQuery:
  1. Create a dedicated read-only service account for Go Fig. (Recommended)
  2. Enable the BigQuery API in your Google Cloud project.
  3. Collect the following details:
  • Google Cloud project ID
  • Service account JSON key file
  • BigQuery location (e.g., US, EU)
Create a dedicated read-only service account so Go Fig never has write access.
1

Create the service account

In Google Cloud Console, go to IAM & Admin → Service Accounts and click + Create Service Account. Name it something like gofig-bigquery, then click Create and Continue.
2

Grant read-only roles

Add these three roles, then click Done:
  • BigQuery Data Viewer: read access to datasets and tables
  • BigQuery Job User: permission to run queries
  • BigQuery Read Session User: efficient reads via the Storage API
3

Generate a JSON key

Open the service account, go to the Keys tab, click Add Key → Create new key, select JSON, and click Create. The key file downloads to your computer.
Save the JSON key file securely. Never commit it to version control or share it publicly.

​
2) Enable the BigQuery API

In Google Cloud Console, select your project, go to APIs & Services → Library, search for “BigQuery API”, and click Enable.
Wait 1-2 minutes after enabling for the API to activate. For sensitive data, you can grant the service account BigQuery Data Viewer on specific datasets instead of the whole project.

​
3) Connect Go Fig to BigQuery

1

Add BigQuery connection

Navigate to your Organization Data page and click Add data source. Select BigQuery from the list of database connections.
The Connect a new data source modal on the Database tab with the BigQuery connector tile highlighted.
2

Enter connection details

Fill in your BigQuery connection information:
  • Project ID: Your Google Cloud Project ID (e.g., my-analytics-project)
    • 6-30 characters, starts with a letter, lowercase letters, numbers, and hyphens only
  • Service Account JSON: Paste the full contents of the JSON key file you downloaded
  • Location: BigQuery location for your data (e.g., US, EU, us-central1); defaults to US
Go Fig validates that the JSON contains type (must be “service_account”), project_id, private_key_id, private_key, and client_email. It should start with {"type": "service_account"...}.
The BigQuery connection form with Project ID, Service Account JSON, and Location fields.
3

Connect to BigQuery

Click Connect to complete the setup. Go Fig will verify the connection, then encrypt and store your credentials securely.
Set the right location: Match the location to where your BigQuery datasets live for best performance. Queries are limited to 90 seconds, so add filters or aggregate before joining large tables if you hit the timeout.