In this article, you'll learn how to set up your Google BigQuery account to work with the Alloy platform.
To obtain credentials, you will need the following:
- Project Id
- Service Account Private Key JSON
As you can see below, Alloy will need this information to make queries to your Big Query instance. You'll want to copy/paste that information in Alloy once you have it. In this guide, we'll explore how to obtain these keys.
To obtain your project Id, navigate to your Google Cloud console's Projects List. You can do so here. Then, choose the Project ID of the project where your BigQuery is in.
First things first, if you don’t have a service account yet, create a service account following Google’s Documentation here.
Then follow the steps in Google’s Documentation here on how to create a private key in JSON format. See sample below showing how a private key in JSON format looks like.
Next, you'll need to configure the Service Account. To do so, follow the simple steps below:
Go to the project principals list in your Google Cloud Console
Click on +Add
In the New Principals field, enter the service account. The service account is the entire email address.
In the Role field, search for the role BigQuery User and select that. Then click on the Save button.
- Input the Project ID for your project found in the previous steps.
- Then copy the whole contents in the JSON file created in the previous steps into the Service Account Private Key JSON field and then click on Validate.
Updated 3 months ago