Skip to main content

Setup Guide - Google BigQuery

This guide will explain the steps necessary to connect your Google BigQuery Enterprise Data Warehouse tenant to Persio.

important

The steps described below require an Administrator level access to Google BigQuery Enterprise Data Warehouse. During the configuration process you may encounter warnings related to potential security risks. While the process of achieving a connection to Persio is guaranteed to be secure, if you are uncomfortable with making the described changes please consult your technical team.

In order to connect Persio with your Google BigQuery Enterprise Data Warehouse tenant you must prepare a Service Account and upload its key file Persio. First, we must prepare this key file. Please follow the guide below.

A) Service Account Creation in Google Cloud Dashboard​

  1. Log in to your Google Cloud Dashboard

  2. Open the sidebar and select IAM & Admin > Service Accounts

Service Accounts Menu
  1. Click the '+ Create Service Account' button
Create Service Account
  1. Enter meaningful, recognizable details for the Service Account. Follow your organization's policy if necessary.
Service Account Details
  1. Click the 'Create and Continue' button
Create and Continue
  1. Assign the roles BigQuery Job User and BigQuery Data Owner to the new service user account, then click the 'Continue' button
Assign Roles
  1. Click the 'Done' button or - optionally - grant users access to this service account. This is nor required for the configuration.
Done Button
  1. Once redirected back to the Service Accounts' list click the account you just created.
Service Account List
  1. Click on the 'Keys' tab
Keys Tab
  1. Click the 'Add key' button and then select the 'Create new key' option
Add Key
  1. On the modal select 'JSON' as a key type
Select JSON
  1. Click the 'Create' button
Create Button
  1. A key file is downloaded to your machine in the background while a notification appear informing you about the creation of the new Service Account key and the potential security risks associated with improper handling or sharing. You may close this notification.
Key Download Notification
  1. Open your Downloads folder and verify that the key file with a .json extension successfully downloaded.

B) Setting up a Workspace in Persio​

Now that you have obtained the Service Account key you can proceed creating your Persio Workspace and Connect it to your Google BigQuery tenant.

  1. Log in to Persio

  2. Click the 'Connect Warehouse' button

Connect Warehouse
  1. Open the dropdown menu under 'Step 1 - Choose warehouse location' and select your preferred datacenter location.
Choose Warehouse Location
  1. Now it is time to upload the key file you prepared in GoogleBigQuery. Click on the 'Upload your keyfile' button.
  1. Locate the key file on your computer and upload it.
  1. Click on the 'Finish' button.
  1. The system will now display a loader icon until the connection between Google BigQuery and Persio is established. This may take up to 30 seconds.
  1. Once the process is finished Persio will display your Dashboard.

Congratulations! You have successfully connected your Google BigQuery Enterprise Data Warehouse tenant to Persio. The system is now ready for data to flow in.

Suggested next​