What is Snowflake?+
Snowflake is a cloud data warehouse, not an ERP or a CRM. Companies use it to combine data from many systems, HubSpot and an ERP included, into one place for reporting and analysis. It’s the warehouse pattern this page describes, not another system you connect point-to-point.
Does HubSpot integrate with Snowflake?+
Yes, through two separate capabilities. Snowflake Data Share is a mature, read-only feature that exposes HubSpot data inside your Snowflake account for querying. A newer Snowflake Direct Sync feature, gated behind Data Hub Enterprise, allows data to flow in the other direction as well.
Is HubSpot’s Snowflake integration read-only?+
Partially, depending on which feature you use. Snowflake Data Share is read-only: HubSpot data flows into Snowflake, not back. A separate, newer Snowflake Direct Sync feature in beta allows Snowflake data to flow into HubSpot records as well, but it’s gated behind Data Hub Enterprise and doesn’t give Snowflake a path back into an ERP.
Do we still need an ERP integration if we have Snowflake?+
Possibly, depending on what you’re trying to solve. If the need is operational, meaning something has to happen in real time across systems, Snowflake doesn’t solve that by itself and a direct integration is still the answer. If the need is reporting, Snowflake usually is the answer.
Why doesn’t HubSpot reporting match my ERP’s numbers?+
Usually because the two systems are each reporting from their own definitions and timing, not because either is wrong. A warehouse pattern, reconciling both systems’ data in one place like Snowflake, is usually a more durable fix than trying to force tighter real-time sync between the two.
Which is more expensive: a data warehouse or an ERP integration?+
It depends on whether you already have the warehouse and the team. If Snowflake and a BI function are already part of your stack, adding HubSpot and ERP data is a modest incremental cost. If you’d be standing up Snowflake for this reason alone, it’s a larger and more ongoing cost than a point-to-point integration would be.
What’s the difference between HubSpot’s Data Share and Direct Sync with Snowflake?+
Data Share is the older, broadly available, read-only feature: HubSpot data flows into Snowflake for querying. Snowflake Direct Sync is newer, in beta, requires Data Hub Enterprise, and supports syncing in either direction, including Snowflake data flowing into HubSpot records.
What HubSpot plan do I need for Snowflake Data Share?+
Data Hub Enterprise. Data Share is included with this plan and isn’t available on lower tiers, and you’ll also need your own Snowflake subscription (Standard, Enterprise, or Business Critical) to receive the share on Snowflake’s side.