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.
Project ID: The Google Cloud project ID for the project containing the target BigQuery data set.
For more information on obtaining the project ID, visit Google Cloud's documentation here.
Credentials JSON: The contents of your Service Account Key JSON file.
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, open Integrations in the Data group of the left-hand navigation (it is not under Settings). If you already have a source connected, you will land on Connected; otherwise you will see Available. 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. After the source is connected, open the BigQuery card and choose Manage source. To pull the latest records, an Admin clicks Sync and Refresh on the source page (that action is admin-only).
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 set up, you can map a component to this data. Visit How to Map a Component to your Data Source for more detailed instructions!