Integrate with Hubspot using CData connector. We utilise official CData Python (opens in a new tab) connector to ingest your data.


Feature NameSupported
Full ImportYes
Incremental ImportYes

Supported streams

We support data extraction from tables and views (opens in a new tab) listed in the official CData documentation, according to the selected API version.

Getting started

Requirements and prerequisites

Hubspot Account.

Set up guide

Create a source

Create a new Source of type CData - Hubspot.

Configure a secret

Add a new secret (or use an existing one). Select OAuth authentication to login with your user account or create a PrivateAppToken in Hubspot. Go to Settings > Integrations in your Hubspot profile to create a PrivateAppToken.

Select the Hubspot API version that you want to use.

Define settings

Configure optional settings

  • Use Display Names - Indicates whether or not technical names or display names are used for tables. We recommend to keep this to false as technical names are easier to process on the data warehouse side.


  • On the AnalyticsBreakdown and AnalyticsContents table you can only select one dimension. Use additional filters and group by to aggregate the data.