BigQuery SQL Setup Guide
Follow our setup guide to connect BigQuery data warehouse to Go Fig.
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.
You will need your project Id
Log in to your Google Cloud Platform account.
Make sure you have logged in to the correct account by checking the account name displayed in the top left corner of the dashboard.
From the account dashboard, copy the Project ID
On the left panel, navigate to IAM & Admin > Service Accounts
At the top, click + Create service account
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`
Click Create and Continue
Add the following Permissions: BigQuery User and BigQuery Data Viewer
Click Done
Navigate to the **IAM & Admin > Service Accounts** page
Find the Service Account you created in Step 2 and click on it (this is where proper naming and descriptions help you here)
Click on Keys from the top navigation
Click Add key > Create new key
Select JSON option and click Create
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.
From the left panel, navigate to the BigQuery Studio page
Click on the drop down to view all the Datasets within your Project
Select the Dataset you want to preview details
Copy the Dataset name at the top of the Preview panel
Note: You may notice under Dataset info that the Dataset ID contains both the project and dataset name separated by a period like this (projectname.datasetname). You will only need to copy the dataset name that follows the period as seen at the top of the Preview panel outlined below.
Navigate to the Network security > Firewall policies page
Click Create firewall rule
Provide a descriptive name and description, for example: name = allow-gofig-ingress, description = Allows gofig to access data in select BigQuery datasets
Set Direction of traffic is to Ingress
Set Action on match is to Allow
Set Source filter to IPv4 ranges
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
Make sure that the IP addresses get saved as separate items, as seen in the screenshot below
Set Protocols and ports to Allow all
Click Create
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.
For the BigQuery connection, the Sync timeframe will pull data from All time
Enter the Project ID from Step 1
Enter the Credentials JSON you created in Step 3
Enter the Dataset ID for the dataset you want to sync with Go Fig you copied in Step 4
Only include one Dataset ID here. If you want to add multiple, you will need to fill the form again.
Toggle on Confirm Firewall Access to confirm you granted access in Step 5
Click Connect. Go Fig will take it from here and sync your data from your BigQuery account.
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.
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
Log in to your Google Cloud Platform account.
Make sure you have logged in to the correct account by checking the account name displayed in the top left corner of the dashboard.
From the account dashboard, copy the Project ID
Step 2: Create Service Account
On the left panel, navigate to IAM & Admin > Service Accounts
At the top, click + Create service account
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`
Click Create and Continue
Add the following Permissions: BigQuery User and BigQuery Data Viewer
Click Done
Step 3: Generate Service Account Key / Credentials JSON File
Navigate to the **IAM & Admin > Service Accounts** page
Find the Service Account you created in Step 2 and click on it (this is where proper naming and descriptions help you here)
Click on Keys from the top navigation
Click Add key > Create new key
Select JSON option and click Create
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
From the left panel, navigate to the BigQuery Studio page
Click on the drop down to view all the Datasets within your Project
Select the Dataset you want to preview details
Copy the Dataset name at the top of the Preview panel
Note: You may notice under Dataset info that the Dataset ID contains both the project and dataset name separated by a period like this (projectname.datasetname). You will only need to copy the dataset name that follows the period as seen at the top of the Preview panel outlined below.
Step 5: Allowlist IP Addresses
Navigate to the Network security > Firewall policies page
Click Create firewall rule
Provide a descriptive name and description, for example: name = allow-gofig-ingress, description = Allows gofig to access data in select BigQuery datasets
Set Direction of traffic is to Ingress
Set Action on match is to Allow
Set Source filter to IPv4 ranges
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
Make sure that the IP addresses get saved as separate items, as seen in the screenshot below
Set Protocols and ports to Allow all
Click Create
Finish Go Fig configuration
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.
For the BigQuery connection, the Sync timeframe will pull data from All time
Enter the Project ID from Step 1
Enter the Credentials JSON you created in Step 3
Enter the Dataset ID for the dataset you want to sync with Go Fig you copied in Step 4
Only include one Dataset ID here. If you want to add multiple, you will need to fill the form again.
Toggle on Confirm Firewall Access to confirm you granted access in Step 5
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
Thank you!