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
A valid Google Cloud Platform (GCP) account.
Google Cloud billing is enabled, and current
Proper permissions to create service accounts and assign roles in the Google Cloud IAM & Admin console.
Step 1: Choose your Google Cloud Project
1. Sign in to your Google account.
2. Go to Google Cloud Console.
3. If prompted, select or create a new project from the project drop-down menu in the top navigation bar. This project will be used for your BigQuery setup.
Step 2: Enable the BigQuery API
1. Ensure you have selected the correct project from the project drop-down menu in the top navigation bar.
2. To enable the BigQuery API, click on the following link: Enable BigQuery API.
Step 3: Create a Service Account
Make sure you are logged in to your Google Cloud Console project.
In the navigation menu, click "IAM & admin" and select "Service Accounts."
Click the "Create Service Account" button to set up a new Service Account.
Enter a unique name for your Service Account (e.g., "Openbridge-BigQuery-Access").
Select "JSON" as the Key type from the dropdown menu.
Click "Create" to create the Service Account.
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.
Step 4: Granting Permissions to Your Service Account
In the Google Cloud Console, by clicking on the hamburger menu (☰) navigate to "IAM & admin" and click "IAM" from the left menu.
Click on the "ADD" button to grant permissions to your Service Account.
Paste the Service Account ID you saved earlier into the "New members" field.
In the "Role" field, select "BigQuery Admin" from the dropdown menu.
Additionally, ensure the "Project Browser" role is also selected to avoid errors.
Click "Save" to grant the necessary permissions to your Service Account.
Step 5: Check Google Cloud Billing
Go to "Billing" in the Google Cloud Console by clicking on the hamburger menu (☰) in the top-left corner, then selecting "Billing" from the menu.
Ensure that billing is active and configured for your project. If it's not, follow the 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!