The following describes the steps and inputs needed to configure a Google BigQuery destination within your Openbridge account. The process is simple and quick, only requiring the minimum information needed to connect and write data to your instance.
Getting Started: Prerequisites
Before you begin, make sure your Google Cloud environment is properly configured. You’ll need:
A Google Cloud Project
Billing enabled for that project
The BigQuery API enabled
A service account with appropriate IAM roles
Not sure how to do this? Follow our step-by-step guide:
👉 Set Up Google BigQuery: Service Account & IAM Configuration
Once your environment is configured, you're ready to proceed with Openbridge integration.
🗺️ Step 1: Select Google BigQuery as Your Destination
In your Openbridge account, go to the Destinations page where all available data warehouse options are listed.
From the list of available options, select Google BigQuery.
🔗 You can directly access the BigQuery here:
👉 Openbridge Google BigQuery Wizard
🔐 Step 2: Provide Authorization
Before proceeding to authorization, you’ll see a checklist screen that confirms your Google Cloud setup.
If you’ve completed all the required steps:
👉 Check all the boxes, then click "Let’s Start!" to begin the authorization process.
Next, you'll be directed to the Authorization page where you’ll add your Google Cloud service account.
To complete this step:
Upload the JSON key file
Drag and drop, or browse to upload the
.jsonfile you downloaded from the Google Cloud Console during the service account setup process.Verify and select your service account
After upload, the associated service account will appear in the list below with its metadata. Confirm that the correct service account is listed. Then click “Select” next to it.Authorize the connection
After selecting the correct service account, click the “Authorize” button to continue.
🏗️ Step 3: Create a BigQuery Dataset
🧾 According to Google:
📦 Do You Have a Dataset Created?
Before Openbridge can deliver data to BigQuery, you must have a dataset created in your Google Cloud project.
If you haven’t already created one, follow this guide:
👉 Google Cloud: Creating Datasets in BigQuery
🎯 How to Create a Dataset
Go to the BigQuery Console.
In the Explorer panel, select the same project where you created the service account and generated the
.jsonkey.
Expand the (⋮) View actions option and click Create dataset.
In the Create Dataset panel:
Dataset ID: Enter a meaningful name (e.g.,
openbridge_data)Location type: Choose
Multi-regionorRegion(based on your GCP setup)
⚙️ Set Table Expiration (Important)
Click Advanced options to expand additional settings.
Under Default table expiration, make sure the checkbox “Enable table expiration” is unchecked.
🔒 This prevents Google from automatically deleting tables after a set number of days, especially in sandbox or unpaid billing scenarios.
Openbridge cannot recover deleted data, so it’s critical this remains disabled.
Click Create dataset to complete the setup.
📚 Step 4: Select Your BigQuery Dataset
After successful authorization, Openbridge will display all available datasets from your connected Google Cloud project.
In this step, you'll select the BigQuery dataset where Openbridge should deliver your data.
If no Datasets are displayed, it is possible that 1) they were not created or 2) the authorization needs to have the correct permissions that allow us to see them. Please confirm a Dataset exists and that your permissions are set correctly.
Once selected, click “Test Connection” to validate that Openbridge can access the dataset.
If successful, you're ready to move on to final configuration.
🏷️ Step 4: Name your destination
Finally, give your destination a unique name,—lowercase letters, numbers, and hyphens only.
For example, my-sales-data. Labels must be unique per destination type.
Enter your name and click Save Your Destination. And that’s it — your destination is live and ready to go!