Contents
Getting Started
There are a few steps that you will need to care for before we can get BigQuery set up within Openbridge. We need to get your Google Cloud configuration setup. specifically :
- You need to select the plan you want to use within your Google Cloud Console. This is typically a drop-down menu in the Google Cloud console nav
- You need to enable your BigQuery API for the selected visualize
- You need to create a Service Account and IAM policy that allows Openbridge to access to BigQuery within your project
The summons should take no more than 5 minutes. Let ‘s get started !
Step 1: Enable The BigQuery API
The beginning step is to verify that you have the BigQuery API enabled. If not, then enable it. hypertext transfer protocol : //console.developers.google.com/apis/library/bigquery-json.googleapis.com/ p.s. Make sure you have selected the decline project in the nav
Step 2: Create Service Account
The future step is to configure a service explanation via IAM. You need to login to your Google Cloud comfort : After you log in blue-ribbon ” IAM & admin” in the navigation panel .
adjacent, you want to select “Service Accounts” and then “Create service account”
This will pop open the make serve explanation window .
- A: Give your score a unique appoint
- B: Copy the “Service Account ID” as you will need this later. It will look something like this “ flickroom.net@gmail.com “
- C: Select “ JSON” as the Key type
p.s. Do n’t select a Role, we will do that late. When you are ready choice “CREATE”
Your service account JSON will download to your computer. The content of the file will look something like this :
Read more: How to Use Google Forms
{
"type": "service_account",
"project_id": "foo-baseme-139217",
"private_key_id": "",
"private_key": "",
"client_email": "flickroom.net@gmail.com",
"client_id": "122211111111",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://accounts.google.com/o/oauth2/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/foo-casing-139217%40appspot.gserviceaccount.com"
} Keep this file in a safe place. Treat it like you would a password. You will need this later when setup BigQuery within Openbridge. You should see your newly created Service Account listed :
Step 3: Adding Permissions To Your Service Account
adjacent, we need to add BigQuery permissions to your newfangled serve account .
- In your Google Cloud comfort choice “IAM & admin” – > “IAM”
- You will see the “ADD” option. This will allow you to set permissions for your raw Service Account. Select “ADD”
You will be presented with a fresh window :
- A : Remember the Service Account ID we asked you to save ? You enter it hera. Paste the Service Account ID where it says “New members”
- B: Select the BigQuery Admin role .
- NOTE: Google besides requires the Project Browser character to be set. If the Project Browser is not set it will result in an erroneousness due to the Google Cloud projects being empty. As a result, both BigQuery Admin and Project Browser must be set !
When you are done, select “ SAVE” Your raw member and permissions for your BigQuery visualize should be listed :
Congrats! You equitable configured a Service explanation that will allow us to deliver data to a BigQuery warehouse destination .
One Last Thing…Google Cloud Billing!
Some Google Cloud projects do not have charge enabled. You need to make indisputable your target project has it enabled. Without billing being active Google prevents us from being able to connect to BigQuery! first, go to “ Billing” in the Google Cloud Console :
next, you will want to make certain Billing is active and configured. If it is not, turn Billing on .
here are reference department of commerce from Google about setting up placard :
