Question 1

What can Polytomic pull from HubSpot into Snowflake?

Accepted Answer

The CRM objects, covering companies, contacts, deals, line items, products, tickets, meetings, calls, emails, notes, tasks, invoices, services, owners and your custom objects. Alongside those sit property histories, associations, engagements, forms and submissions, lists and memberships, pipelines, marketing events and participants, email events and campaigns, workflows and subscription changes. Custom properties are discovered dynamically, and association labels and identifiers, including ones you defined yourself, are exposed as fields.

Question 2

How do incremental reads work?

Accepted Answer

For the primary CRM objects, the HubSpot Search API finds records changed since the last run by last modified date, and a batch read then fetches the full set of properties and associations for those records. The initial load uses the list API instead, because there is nothing to compare against yet. Some event style datasets carry their own timestamp cursors rather than going through search.

Question 3

Are deleted or archived records reflected?

Accepted Answer

Not through incremental reads, and this is the one behaviour worth designing around rather than discovering later. HubSpot's incremental API does not report deletions, so a record removed in HubSpot will not be marked as removed in the data warehouse by an incremental run. The options are full refresh mode, or periodic full resyncs so that reconciliation removes rows no longer present. Some entity types do expose an archived or deleted timestamp field, but that is not general delete tracking across the CRM. Most teams run incremental ETL frequently and a full resync on a slower cadence.

Question 4

Does our HubSpot tier affect what we can sync?

Accepted Answer

Yes, more than people expect. Availability of several datasets depends on your HubSpot product tier and on which optional scopes you grant, with services, tickets, line items, invoices, and the marketing and email datasets being the common ones that turn out to be unavailable on a lower tier. API limits are also portal and tier dependent. Polytomic reads your actual allowance where HubSpot reports it and stays under it rather than assuming a fixed number.

Question 5

Why replicate HubSpot into a data warehouse?

Accepted Answer

Mostly for history and for joins. HubSpot reflects current state well, but there is nothing in it that stamps a deal amount historically in a way you can query, so questions about how a quarter actually developed are hard to answer from the CRM alone. ETL into a data warehouse gives you that history at your own grain, and puts CRM records next to product usage, billing and support data so the joins people keep asking for become ordinary SQL.

Sync HubSpot to Snowflake

Sync HubSpot to Snowflake with Polytomic

Property history included

Custom properties discovered

Objects and associations

Or sync Snowflake to HubSpot

Trusted by businesses worldwide

Step-by-step integration guide

Connect HubSpot in Polytomic

Connect Snowflake in Polytomic

Create a sync between HubSpot and Snowflake

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect HubSpot with Snowflake?