BigQuery integration
Viva Goals can integrate with Google BigQuery to automatically update your OKRs.
Consider this example: You have data in your BigQuery warehouse that tracks the number of converted leads. Your goal is to increase the value of converted leads to a certain amount. If you implement BigQuery integration, you can save yourself from repeatedly going back and forth between BigQuery and Viva Goals to update your progress. Viva Goals will sync the values for you and chart your progress toward goals, saving time and keeping your OKRs current.
Viva Goals uses a service account with OAuth 2.0 to call into the Google BigQuery APIs. For BigQuery integration, you need to add the Viva Goals service account, ally-bigquery@ally-346417.iam.gserviceaccount.com, to your BigQuery project and provide the required access and permissions. Read on for step by step instructions.
Follow these steps in your Google Cloud platform console to create a role:
Log in to your google cloud platform developers console, https://console.developers.google.com/.
Go to the "hamburger" menu in the upper-left corner of the screen and choose IAM & Admin -> Roles.
At the top of the roles screen, select + Create Role.
Enter the details in the form. Then select Add Permissions and add the following permissions:
bigquery.datasets.get
bigquery.jobs.create
bigquery.tables.get
bigquery.tables.getData
Select Create to complete role creation.
Now it's time to assign the new role to the Viva Goals service account so Viva Goals has permissions to read information from BigQuery and connect it to your OKRs.
Go to the "hamburger" menu in the upper-left corner of the screen and choose IAM & Admin -> IAM.
Select the + Add button at the top of the page.
For Add screen, add the Viva Goals service account email, as noted below, in the New Principals field:
ally-bigquery@ally-346417.iam.gserviceaccount.com
Select Save to complete setup.
The admin can follow these steps to set up BigQuery integration in Viva Goals:
Go to the Viva Goals integrations page through Admin > Integrations.
Scroll through the integration options until you find BigQuery. Select enable if this is the first time or manage if an integration was previously established.
Select New Connection. In the dialog that opens, enter the connection name and the BigQuery Project ID that holds the data you want to connect to your OKRs.
Viva Goals uses a service account with OAuth 2.0 to call into the Google BigQuery APIs. Add the Viva Goals service account to your BigQuery project and provide the required access and permissions.
Select Next to finish setup.
Viva Goals lets you connect with multiple BigQuery projects. Select New connection to add another connection. You differentiate connections by name. Those names are displayed to members when they link their OKRs to BigQuery data.
After setup is complete, users in your organization can link the success of their OKRs directly to data in BigQuery cloud datasets.
When you create or edit an objective or key result, select Connect data source to auto-update progress.
From the list of integrations, select BigQuery.
If you already created a BigQuery connection, or an administrator in your organization shared a BigQuery connection with you, that connection will be automatically selected. If no connections were already created or shared, Viva Goals will prompt you to add a new connection.
Add the BigQuery SQL query that will return a single-valued numeric value. This value will be connected to the OKR's progress or KPI depending on how the OKR is measured.
Select Next to finish and save your OKR. You should now see a BigQuery icon next to the OKR. The OKR will sync automatically every hour, but you can also select refresh to refresh it manually.