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 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.