📘
Tability Guides
Back to the appWebsiteAPILegal
  • About Tability
    • How does Tability work?
    • Navigating your Free Trial
      • Tability Free Trial FAQs
      • Tability Buyer's Guide
      • Tability Basic vs. Premium
    • Download the mobile app
  • Getting Started
    • How to set up your Tability workspace
    • Getting started with Tability for Enterprise
    • Tracking OKRs and tasks with Tability
    • Tability Frequently Asked Questions
  • Tability OKR onboarding
    • OKR implementation planning
    • Top down vs. Bottom up OKRs
    • Aspirational vs. Committed goals
    • Getting good goal updates from your team
    • Running a weekly routine
    • The complete Tability guide to OKRs
  • Features
    • Plans
      • Creating and editing Plans and sub-plans
      • Goal-setting AI
      • Bulk importing plans
      • Plan Score
      • Owners and Contributors
      • Editing outcomes/key results
      • Strategy Map
    • Outcomes/Key Results
      • Finding your goals in Tability
      • Outcome types
      • Outcome relationships
      • Data sources
      • Cascading Map
    • Check-ins
      • Check-ins overview
      • How to create check-ins
      • Using the Check-ins API
      • How to automate check-ins
    • Reporting
      • Presentation Mode
      • Sharing presentations externally
      • TV Mode
      • Workspace Insights
      • Strategy Map
      • Cascading Map
      • Filters
      • Retrospectives
      • Custom Dashboards
    • Standups
    • AI features
      • Coaching AI
      • AI metric detection
      • Goal setting AI
    • Security & Admin
      • SAML SSO - Microsoft Azure Directory
      • SAML SSO - OneLogin
      • SAML SSO - Okta
      • SCIM Provisioning - Okta
      • SAML SSO - Google
    • Workspace Settings
      • Managing users and roles
      • Inviting users
      • Customise the default workflows
      • Customise terms
      • Customising the UI
      • Deleting your workspace
      • OKRs with Tability
    • Account
      • Account settings
      • Deleting your account
  • Integrations
    • Auto-sync for data sources
    • Amplitude
    • Asana
    • BigQuery
    • ChartMogul
    • ClickUp
    • Confluence
    • Gitlab
    • Github
    • Google Sheet
    • Google Integrations
    • Hubspot
    • Jira
    • Linear
    • Microsoft Teams
    • OpenAI
    • Power BI
    • Salesforce
    • Tableau
    • Slack
    • Zapier
  • Other
    • How to get more AI credits
  • Support
Powered by GitBook
On this page
  • Privacy
  • How to enable the integration
  • Step 1. Upgrade to the Plus or Premium subscription
  • Step 2. Connect your Google account to Tability
  • How to add a data source to an outcome of Key Result
  • Step 1. Open up your edit panel of your outcome/KR
  • Step 2. Select BigQuery as a data source
  • Step 3. Select the project and add your SQL query
  • Step 4. Save your connection
  • How to use the data source in your check-ins

Was this helpful?

  1. Integrations

BigQuery

Last updated 9 months ago

Was this helpful?

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, 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.

  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 👇

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

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

Step 2. Select BigQuery as a data source

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 👇

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

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.

Google API Services User Data Policy