Generating a service account key:

Creating a Role

  1. Go to your Google Cloud Console, under the IAM tab, select the option of Roles.

  2. Create a new role with launch stage as General Availability.

  3. In Add permission option add the 2 permissions(both are mandatory) -
    bigquery.jobs.create
    bigquery.tables.getData

  4. Save this role.

Creating a Service Account

  1. Moving onto the next step - Under the IAM tab, select the Service accounts option.

  2. Select a project for which the service account has to be created.

  3. Then head to creating a new service account

  4. In the Service account name field, enter a name.

  5. The Cloud Console fills in the Service account ID field based on this name.

  6. In the Service account description field, enter a description. For example, service account for bigquery integration.

  7. Click Create and continue.

  8. 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).

  9. Click Continue.

  10. Click Done to finish creating the service account.

Creating a service account key:

  1. In the Service Account created above, under the Action tab, select Manage Keys option.

  2. Click Add key, select key type as JSON.

  3. Click Create. A JSON key file is downloaded to your computer.

  4. The content of the downloaded JSON key will be required while you’re integrating Bigquery with Peoplebox.

Adding the key to Peoplebox

  1. Edit the Key result you want to integrate BigQuery with.

  2. Select the option - Automatic Updates from - Then select BigQuery

  3. 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.

  4. In the Specify Input Fields section, just type a query to fetch a single numerical value and select the SQL type and click Verify.

  5. Save Changes to save the integration.

Don’t see an integration with your favorite tool? Feel free to suggest one here.

Did this answer your question?