TL;DR Short answer: if you are on HubSpot's Data Hub Enterprise and use Snowflake, start with HubSpot's own Snowflake Data Share, which needs no pipeline at all. Everyone else needs a HubSpot ETL tool, and the one detail that separates them is associations: contacts, companies and deals only make sense joined, and connectors differ most in how completely they extract the links between them. Ten options:
Airbyte Fivetran HubSpot Snowflake Data Share Stitch Data Supermetrics Hevo Data Boomi Data Integration Matillion Estuary Flow Meltano One HubSpot constraint: API limits are shared by every integration in your HubSpot account and scale with your subscription tier, and the CRM search endpoint many tools use for incremental reads returns at most 10,000 results per query. Large initial loads and busy accounts are where pipelines slow down or fail.HubSpot ETL tools move CRM, marketing and service data out of HubSpot into a warehouse, where it can be joined with product usage, billing and support data from other systems. That is where full-funnel attribution, pipeline forecasting and lifecycle reporting become possible beyond HubSpot's own reports.
Three things. First, associations: HubSpot stores the links between contacts, companies, deals and tickets separately from the records themselves, so a connector that skips them leaves you with tables you cannot join. Second, properties: portals often have hundreds of custom properties, and property history is a separate extraction. Third, authentication: HubSpot retired API keys in November 2022, so connections now use OAuth or a private app access token with explicit scopes, and a missing scope silently drops an object.
How do the HubSpot ETL tools compare? Tool Built for Destinations Hosting Pricing basis Airbyte Data teams, many sources Any Cloud or self-hosted Free self-hosted; Cloud volume-based; Pro and Flex capacity-based Fivetran Data teams wanting no upkeep Any Cloud Monthly active rows HubSpot Snowflake Data Share Data Hub Enterprise customers Snowflake only HubSpot and Snowflake Included in Data Hub Enterprise Stitch Data Teams with simple needs Major warehouses Cloud Row volume tiers Supermetrics Marketing teams Warehouses, Sheets, Looker Studio Cloud Plan by sources and destinations Hevo Data Teams without engineers Major warehouses Cloud Events Boomi Data Integration ELT plus reverse ETL Major warehouses Cloud Credits Matillion In-warehouse transformation Snowflake, Databricks, Redshift Your cloud account Credits Estuary Flow Near real-time pipelines Warehouses and streams Cloud or private deployment Data volume Meltano Engineers who want code Any Singer target Self-hosted Free, open source
Which HubSpot ETL tools should you consider? Every option below reads HubSpot natively. Check two things on any shortlist: whether it extracts associations and custom objects, and whether it authenticates with a private app token or OAuth.
1. Airbyte Airbyte is an open-source data integration platform with 700+ connectors and a community of 25,000+ data engineers. Its HubSpot source authenticates with OAuth or a private app access token and syncs contacts, companies, deals, tickets, engagements, marketing objects, custom objects and the associations between them, incrementally where HubSpot supports it. It loads into any Airbyte destination and works with dbt for modelling.
What's unique about Airbyte? If one HubSpot stream fails, you can relaunch that stream alone rather than rerunning a dozen object types. Connectors are open source and editable, and the Connector Development Kit covers anything else. It runs as self-hosted open source, on Airbyte Cloud, or as Enterprise Flex, which keeps the data plane in your own environment when customer records must stay there.
2. Fivetran Fivetran is a closed-source, managed ELT service with 700+ connectors, including HubSpot. It handles schema changes automatically and needs no infrastructure. It bills on monthly active rows, and CRM data churns as properties update, so a busy HubSpot portal can generate more active rows than its record count suggests.
Here is a closer look at Airbyte vs Fivetran .
3. HubSpot Snowflake Data Share HubSpot's own Snowflake Data Share uses Snowflake's secure data sharing, so HubSpot data appears in your Snowflake account without being copied or loaded, and without adding to your storage bill. It is included with Data Hub Enterprise, which HubSpot renamed from Operations Hub at INBOUND 2025, and you must already be a Snowflake customer. Data flows one way only, and it does nothing for BigQuery, Redshift or Databricks users.
4. Stitch Data Stitch is a cloud extract-and-load platform with 140+ connectors, including HubSpot, originally built on the Singer specification. It has no user-defined transformations and suits straightforward loading. Qlik acquired Talend, and Stitch with it, in 2023, and now publishes a migration path from Stitch to Qlik Talend Cloud, which is worth weighing before committing.
Here is a closer look at Airbyte vs Stitch .
5. Supermetrics Supermetrics is a marketing data pipeline platform with a HubSpot connector alongside Google Ads, Meta, LinkedIn and other ad platforms. It suits marketing teams who want HubSpot campaign, contact and deal data blended with paid channels in a warehouse, Google Sheets or Looker Studio without a data engineer. It covers the fields its connector exposes rather than the full CRM object model.
6. Hevo Data Hevo Data is a no-code cloud ELT platform with around 150 integrations including HubSpot. It applies transformations before data reaches the destination and can sync results back to source APIs. Pricing is event-based, which is worth modelling upfront if your HubSpot portal generates a lot of activity.
7. Boomi Data Integration (formerly Rivery) Boomi acquired Rivery in December 2024 and now sells it as Boomi Data Integration. It has a HubSpot connector and bundles transformation, orchestration and reverse ETL, so warehouse-modelled data can be pushed back into HubSpot properties. Pricing is in credits that vary by connector, which can make cost hard to model.
8. Matillion Matillion's cloud platform has a HubSpot connector and pushes transformation down into Snowflake, Databricks or Redshift, with dbt support since v1.70. It bills in credits tied to job runtime and makes most sense when Matillion already runs your warehouse transformations.
Here is a closer look at Airbyte vs Matillion .
9. Estuary Flow Estuary Flow is a streaming-first platform with a HubSpot connector that captures changes in near real time rather than on a schedule, backfilling history at the same time. It suits teams whose downstream uses, such as lead routing or alerting, need CRM changes within minutes. It has a smaller connector catalogue than the established platforms, and frequent capture draws on your HubSpot API allowance.
10. Meltano Meltano is an open-source, CLI-first platform spun out of GitLab that manages taps and targets as a version-controlled project, with HubSpot extractors available on Meltano Hub. It suits teams who want pipelines defined in code and reviewed like software. Connector quality varies by variant, so check which HubSpot extractor is maintained before committing.
How do you get HubSpot data into Snowflake or BigQuery? There are three routes, and your HubSpot plan narrows them quickly:
Snowflake Data Share: if you have Data Hub Enterprise and Snowflake, this is the least work, with no pipeline or copies to manage.An ETL tool: for BigQuery, Redshift, Databricks, or Snowflake without Data Hub Enterprise, a connector such as Airbyte or Fivetran pulls HubSpot through its API on a schedule, alongside your other sources.Manual exports: HubSpot's CSV exports work for a one-off analysis but drop associations and property history, so they rarely suit ongoing reporting.Whichever route you use, model associations explicitly in the warehouse. A deal joined to its primary company, and a contact joined to all its deals, is what turns raw HubSpot tables into pipeline and attribution reporting.
How do you start syncing HubSpot data with Airbyte? Step 1: Set up HubSpot as a source In Airbyte, open Sources, choose New source and select HubSpot. Authenticate with OAuth, or create a private app in HubSpot's settings with read scopes for every object you need, including associations and custom objects, and paste its access token. Set a start date for historical data and run the connection test.
Step 2: Set up a destination Choose where the data lands: a cloud warehouse such as Snowflake, BigQuery or Redshift, a data lake, a database or cloud storage.
Step 3: Configure the connection Select the objects you need, including the association streams, use incremental sync where available, and schedule the first full load outside business hours, since it shares HubSpot's API limits with your other integrations.
The process is the same in Airbyte Open Source, which you can deploy yourself , and in Airbyte Cloud, which you can try free for 14 days .
Which HubSpot ETL tool should you choose? If you have Data Hub Enterprise and Snowflake, use the Data Share first. Otherwise, choose by who owns the pipeline. Data teams with several sources get the most from Airbyte, self-hosted or in Cloud, or Fivetran if they prefer fully managed and the row-based bill works. Marketing teams blending HubSpot with ad spend fit Supermetrics. Hevo, Stitch and Boomi suit simpler no-code needs, with Boomi adding reverse ETL. Estuary is for near real-time use cases, Matillion where it already runs your transformations, and Meltano for pipelines in code.
For tools that cover more than HubSpot, see our guide to the top data integration tools .
Sync HubSpot with Airbyte Move HubSpot contacts, companies, deals and associations into Snowflake, BigQuery or any Airbyte destination, alongside your product and billing data, self-hosted or in Airbyte Cloud.
Try Airbyte Cloud free for 14 days or talk to our team .
Frequently Asked Questions (FAQs) 1. Does HubSpot still support API keys? No. HubSpot retired API keys in November 2022. Integrations now authenticate with OAuth or a private app access token, which has explicit scopes for each object it can read.
2. What do you need for HubSpot's Snowflake Data Share? A Data Hub Enterprise subscription, formerly Operations Hub Enterprise, and an existing Snowflake account. The share is one-way, from HubSpot to Snowflake, and does not copy data or add to your Snowflake storage.
3. How do you move HubSpot data to BigQuery? Use an ETL tool with a HubSpot source and a BigQuery destination, such as Airbyte, Fivetran or Hevo. HubSpot's native Data Share only supports Snowflake.
4. Why are my HubSpot tables hard to join in the warehouse? Usually because associations were not extracted. HubSpot stores links between contacts, companies, deals and tickets separately from the records, so make sure your connector syncs the association streams and that your private app has the scopes to read them.
Suggested reads Salesforce ETL Tools
Zoho CRM ETL Tools
Data Ingestion Tools
Data Synchronization Tools
.webp)