Generating a service account key:
Creating a Role
Go to your Google Cloud Console, under the IAM tab, select the option of Roles.
Create a new role with launch stage as General Availability.
In Add permission option add the 2 permissions(both are mandatory) -
Save this role.
Creating a Service Account
Moving onto the next step - Under the IAM tab, select the Service accounts option.
Select a project for which the service account has to be created.
Then head to creating a new service account
In the Service account name field, enter a name.
The Cloud Console fills in the Service account ID field based on this name.
In the Service account description field, enter a description. For example,
service account for bigquery integration.
Click Create and continue.
Click the Select a role field. Select the newly created role in Step 1. You can grant a predefined role or custom role that meets your needs. (Make sure the role has permission to run queries on your project).
Click Done to finish creating the service account.
Creating a service account key:
In the Service Account created above, under the Action tab, select Manage Keys option.
Click Add key, select key type as JSON.
Click Create. A JSON key file is downloaded to your computer.
The content of the downloaded JSON key will be required while you’re integrating Bigquery with Peoplebox.
Adding the key to Peoplebox
Edit the Key result you want to integrate BigQuery with.
Select the option - Automatic Updates from - Then select BigQuery
In the Authorize part, give the connection a name and copy the complete json file you download in the previous step in the Service Account Key text box.
In the Specify Input Fields section, just type a query to fetch a single numerical value and select the SQL type and click Verify.
Save Changes to save the integration.
Don’t see an integration with your favorite tool? Feel free to suggest one here.