Skip to main content
All CollectionsIntegrations
BigQuery Integration Overview
BigQuery Integration Overview

Learn how to connect BigQuery to QuotaPath

Updated over 10 months ago

QuotaPath's integration with BigQuery allows you to easily import data from a Google Cloud project to use in QuotaPath to calculate commissions or inform payouts eligibility. In this article, we'll cover the requirements to set up this integration and provide step-by-step instructions.


Integration Requirements

Before connecting BigQuery to your QuotaPath workspace, you'll need to obtain the below information.

  1. Project ID: The Google Cloud project ID for the project containing the target BigQuery data set.

    1. For more information on obtaining the project ID, visit Google Cloud's documentation here.

  2. Credentials JSON: The contents of your Service Account Key JSON file.

    1. For more information on obtaining your service account key, visit Google Cloud's documentation here.

Once you have the above information, you're ready to connect BigQuery to your QuotaPath workspace!


How to connect BigQuery

To connect BigQuery to your QuotaPath workspace, click Settings in the main app navigation, and then Integrations. Find the BigQuery integration card and click ‘Connect’.

Integration Source Form

Enter the Project ID and Credentials JSON into the integration settings form and click 'Submit'.

After receiving the confirmation that the integration has been successfully connected, click 'Next' to proceed.

Sync Schedule

At the top of the following screen, use the dropdown selector to set the sync frequency. In addition to these scheduled syncs, you'll always have the option to click 'Sync Now' on the BigQuery integration card on the Integrations page to trigger a manual sync.

Objects

Next, select the objects that you'd like to import into your QuotaPath workspace.

When complete, click ‘Sync now’ to begin importing data into your QuotaPath workspace. This could take a few minutes so feel free to close the modal and navigate back to Home to complete any outstanding onboarding tasks. We will send you an email once your integration is ready to use.

Once your integration is setup, you can start syncing your plan to your integration data. Visit this article for more detailed instructions!

Did this answer your question?