> For the complete documentation index, see [llms.txt](https://guides.tability.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://guides.tability.io/docs/become-a-tability-power-user/integrations/bigquery.md).

# BigQuery

You can connect Tability to Google BigQuery to automatically pull data for your check-ins without having to switch context.

Once you add BigQuery as a data source for an outcome/Key Result, Tability can:

* Pull the most recent value of the metric when you open the check-in form.
* Automatically sync your metric while the plan is active (Premium subscription only).

## Privacy

Tability's use and transfer of information received from Google APIs to any other app will adhere to[ Google API Services User Data Policy](https://developers.google.com/terms/api-services-user-data-policy#additional_requirements_for_specific_api_scopes), including the Limited Use requirements.

## How to enable the integration

### **Step 1. Upgrade to the Plus or Premium subscription**

You'll need to have a *Plus subscription* to use BigQuery as a data source and automatically pull the metric value in the UI for your check-ins.

You'll need to have a *Premium subscription* to enable the sync.

### Step 2. Connect your Google account to Tability

BigQuery is a Google product, and you will need to connect your personal Google account to be able to use this integration.

<figure><img src="https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FPl9Kd0C4BQgmGQi1XOnV%2Fimage.png?alt=media&amp;token=04c4b5d4-051e-4ed3-b4f5-3070af5502c1" alt=""><figcaption></figcaption></figure>

1. Go to the personal integrations admin by clicking on your profile picture and then **Personal integrations**
2. Connect to Google

Once connected, the integration panel should look like the picture below 👇

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2F5cKGcYxdqAyFPinuLKHt%2Ffile-P4KKLvJX6r.png?alt=media\&token=07034f5a-6047-4fee-8226-60d295fb47c8)

## How to add a data source to an outcome of Key Result

Once Google is connected, you will be able to use it as a data source for your outcomes/KRs.

### **Step 1. Open up your edit panel of your outcome/KR**

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FKR9nZnKw6qYogqMG3mvw%2Ffile-bZLSr0JQOb.png?alt=media\&token=89a55e57-058d-4b2d-989b-fc91821b0b83)

Click on "Edit" to open up the Edit panel of any outcome/KR in your workspace.

### **Step 2. Select BigQuery as a data source**

<figure><img src="https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FnMwKeOqQsnHiEB0tX2Dd%2Fimage.png?alt=media&amp;token=f78adae9-c92b-4713-b60f-61ce504cf584" alt=""><figcaption></figcaption></figure>

Go to the "Data source" tab and select BigQuery.

### **Step 3. Select the project and add your SQL query**

Use the dropdown to select the project, and add the SQL query that you need to pull the right data from BigQuery.

### **Step 4. Save your connection**

Click on "Save & preview" to complete the connection.

Tability will retrieve the current value for that metric and your screen should look like this 👇

<figure><img src="https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FPrAaRO49CqJv6kDdrRr4%2Fimage.png?alt=media&amp;token=beb38dbf-b814-454f-9ce0-e67d2178f024" alt=""><figcaption></figcaption></figure>

You can now toggle the option to Enable auto-sync of your metric if you're on a Premium subscription.

Tability will retrieve the value of your metric from BigQuery every other day, and will create a check-in on behalf of the owner of the outcome/KR.

The first data sync should happen within 1h of enabling this option.

## How to use the data source in your check-ins

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FtMQNJZIIlkIpiaZCnoP7%2Ffile-oz99rNyaxc.png?alt=media\&token=bf961bf1-330b-4403-8a2e-5f0823fd9739)

It's all automatic! Once an outcome/KR is connected to a data source, Tability will automatically pull the current value whenever you open up the check-in modal.
