Setting up the HubSpot → Google BigQuery pipeline

Before you start: requirement information

To set up a HubSpot → Google BigQuery pipeline, you need to meet the following requirements:

1. Make sure you are a Super Admin of your HubSpot account.
2. Follow the instructions to create a Private App and get an Access Token.
3. Get the OWOX BI service account ID from your customer success manager
4. Follow the instructions to grant OWOX BI access to your BigQuery dataset or an entire project.
5. Share your GCP project id and dataset id with your customer success manager. 

Provide the information above to your customer manager.

Step-by-step instruction

To set up Google Ads → BigQuery pipeline, you need to follow the steps below:

1. On the OWOX BI main page, click the 'New' button and choose 'Pipeline':

2. As a service provider, select 'HubSpot':

3. Choose pipeline 'HubSpot → Google BigQuery':

And click the 'Create & Setup' button:

4. Pipeline successfully created. And now you can schedule a call with the manager and provide him/her with the required information.

Supported sync modes

The HubSpot → Google BigQuery pipeline supports the following sync modes:

• Full Refresh
• Incremental