> 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="/files/ujtCmX3QcsDrehZxVu8d" 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 👇

![](/files/RTiswwnhNFOWuLV8rctV)

## 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**

![](/files/DNmMRUeu4l5wgOzggwys)

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="/files/WIkayOPKoXrynj4x5JUW" 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="/files/Lgq8qW2DLaLsuwygcMYR" 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

![](/files/DnjKVO7ZFxR1BvVreGdr)

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.
