Google BigQuery is an analytics web service in the cloud that specializes in handling extensive datasets for analysis purposes. It is particularly effective for processing immense volumes of data, typically consisting of billions of rows. BigQuery employs a SQL-like language for querying and retrieving information from these datasets.

What you can do with BigQuery and Profit.co Integration?

Integrate Bigquery in Profit.co key result and automate the progress. You can now integrate BigQuery with Profit.co and modernize your smart analytics warehouse by creating key results and performing check-ins instantly.

Step 1:

Navigate to Settings from the left navigation panel.

Click on Integrations, On the Connectors page, Select the User Level tab and enable the BigQuery toggle.

all_my_okrs
user_level

After enabling it, navigate to Preference from the left navigation panel, select the Integrations tab, and select the Big Query Manage button to make a connection.

integartions

Then click the Sign in to BigQuery button.

manage

Step 2:

Enter the Connection Name and click on the Sign in to BigQuery button to successfully configure the BigQuery Integration connection.

sign_in_bigquery

Enter your email address, password and click Next.

sign_in

Account Password

Select Allow for access.

Account Password

Step 3:

Now Create a key result Using the Form in Profit.co where you want to integrate the BigQuery in a key result.

Note: BigQuery supports Increase KPI, Decrease KPI, or Control KPI type.

Enter the Key Result name, and choose the required Key Result type and KPI.

no_of_blogs

Select the Automate Check-in and choose BigQuery from the Connection dropdown.

automate_checkin

On the Connect to BigQuery tab, Choose your Projects, enter the Query, and Run it.

run

You will find the Current Value. Finally, click on the Add button.

Add-current-value

Once the Key Result is successfully created, click on the Check-in button and complete the Check-in to update the status value in the key result.

created-key-result
check-in-score

If you check-in you’ll be redirected to the review page. Finally, you can Update it to make progress to your key result.

Update Check-in
updated-check-in-key-result

Note: The automatic check-in will happen every day at 09.00 AM based on the user region.