Google BigQuery is a powerful enterprise data warehouse that allows you to run super-fast SQL queries using Google's infrastructure.
Openbridge supports data delivery to BigQuery warehouse destinations, and if you're new to BigQuery, you can start with their free tier to get started with your data analysis.
This step-by-step guide will walk you through the process of setting up BigQuery within Openbridge, focusing on creating and configuring Service Accounts in the Google Cloud Console. No prior experience is required, and we'll make it easy for you!
🔧 Prerequisites
Before getting started, make sure:
✅ You have a valid Google Cloud account and an active project
✅ Billing is enabled for the project
✅ You have permissions to:
Create service accounts (
Service Account Admin)Assign IAM roles (
IAM Role Admin)
🚀 Step 1: Choose or Create Your Google Cloud Project
Sign in at Google Cloud Console.
In the top navigation bar, open the project selector.
Select an existing project or click "New Project".
Choose a meaningful name (e.g.,
openbridge-bigquery) and note the Project ID.
📡 Step 2: Enable the BigQuery API
Verify your project is selected in the Cloud Console.
Open the API enablement link:
👉 Enable BigQuery APIConfirm and enable the API.
👤 Step 3: Create a Service Account & Assign Permissions
Select the Project you've created
Click "Create Service Account".
Enter the following:
Service Account Name:
openbridge-bigquery-accessService Account Id:
openbridge-bigquery-accessDescription: (optional)
Click Create and Continue.
🔐 Assign Permissions (on the same screen)
In the "Role" field, select "BigQuery Admin" from the dropdown menu.
Additionally, ensure the "Project Browser" role is also selected to avoid errors.
Click Continue, then Done.
🔑 Generate a Service Account Key
Now you are able to see the service account you've create for the selected project.
(You will find the service account at IAM & Admin > Service Accounts &
Select the project)
After service account creation, click the service account to open details.
Go to the "Manage Keys" tab.
Click “Add Key” → “Create new key”.
Select JSON and click Create.
A JSON file containing credentials for the Service Account will be downloaded to your computer. Keep this file secure, as it grants access to your BigQuery resources.
⚠️ Important: Do not commit this key to source control. Use Secret Manager or Vault to store it securely.
💳 Step 4: Confirm Billing Is Active
Visit the Billing Console.
Under "My Projects", confirm your project is linked to an active billing account.
If needed, follow prompts to enable billing.
Congratulations! You have successfully configured your Service Account to access BigQuery. You are ready to use BigQuery with Openbridge and seamlessly analyze your data. Happy querying!