Skip to main content

BigQuery Destination Setup Guide for Openbridge

Openbridge Support avatar
Written by Openbridge Support
Updated today

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:

  1. Upload the JSON key file

    Drag and drop, or browse to upload the .json file you downloaded from the Google Cloud Console during the service account setup process.

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

  3. Authorize the connection

    After selecting the correct service account, click the “Authorize” button to continue.

✅ Step 3: Create a Dataset

What is a Dataset?
According to Google:

"Datasets are top-level containers used to organize and control access to your tables and views."

📦 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
​

Did this answer your question?