BigQuery SQL Setup Guide

Follow our setup guide to connect BigQuery data warehouse to Go Fig.

Prerequisites

To connect BigQuery to Go Fig, you will need access to an active Google Cloud Platform account with Administrator access to create a Service Account and manage network firewalls.

Setup instructions

Step 1: Copy Your Google Cloud Platform Project ID

You will need your project Id

1. Log in to your Google Cloud Platform account.

2. From the account dashboard, copy the Project ID

Step 2: Create Service Account

1. On the left panel, navigate to IAM & Admin > Service Accounts

2. At the top, click + Create service account

3. Give the service account a descriptive name and description. For example: Name=Go Fig BigQuery Integration, Description=This is used by gofig to access data in select BigQuery datasets

4. Click Create and Continue

5. Add the following Permissions: BigQuery User and BigQuery Data Viewer

6. Click Done

Step 3: Generate Service Account Key / Credentials JSON File

1. Navigate to the IAM & Admin > Service Accounts page

2. Find the Service Account you created in Step 2 and click on it (this is where proper naming and descriptions help you here)

3. Click on Keys from the top navigation

4. Click Add key > Create new key

5. Select JSON option and click Create

6. You will see a file start downloading to your local device immediately. Open the file in a simple text editor like Notepad. Keep this file open, you will need it to configure Go Fig.

Step 4: Identify the Dataset ID you want to give Go Fig access to

1. From the left panel, navigate to the BigQuery Studio page

2. Click on the drop down to view all the Datasets within your Project

3. Select the Dataset you want to preview details

4. Copy the Dataset name at the top of the Preview panel

Step 5: Allowlist IP Addresses

1. Navigate to the Network security > Firewall policies page

2. Click Create firewall rule

3. Provide a descriptive name and description, for example: name = allow-gofig-ingress, description = Allows gofig to access data in select BigQuery datasets

4. Set Direction of traffic is to Ingress

5. Set Action on match is to Allow

6. Set Source filter to IPv4 ranges

7. Copy and paste the following IP addresses from our partner Airbyte: 34.106.109.131, 34.106.196.165, 34.106.60.246, 34.106.229.69, 34.106.127.139, 34.106.218.58, 34.106.115.240, 34.106.225.141

8. Set Protocols and ports to Allow all

9. Click Create

Finish Go Fig configuration

1. In the BigQuery Connection Setup form, enter the Collection name of your choice. We recommend you give it the same name as the Dataset ID you plan to sync.

2. For the BigQuery connection, the Sync timeframe will pull data from All time

3. Enter the Project ID from Step 1

4. Enter the Credentials JSON you created in Step 3

5. Enter the Dataset ID for the dataset you want to sync with Go Fig you copied in Step 4

6. Toggle on Confirm Firewall Access to confirm you granted access in Step 5

7. Click Connect. Go Fig will take it from here and sync your data from your BigQuery account.

Note

Go Fig partners with Airbyte to manage connections with your external accounts and sync data to Go Fig. Go Fig does not store any information provided in the Connection Setup forms. For more information on how Airbyte works, see their documentation here.

Updated on: 06/06/2025