Question 1

Which HubSpot objects can a ClickHouse model write to?

Accepted Answer

Companies, contacts, deals, tickets, products and line items, activities such as calls, meetings, emails, notes and tasks, plus invoices, services, custom objects, static lists and custom behavioural events. The custom behavioural events target is worth noting here, since it lets product activity from ClickHouse arrive in HubSpot as events rather than as a field somebody has to interpret.

Question 2

How does the incremental read actually bound itself?

Accepted Answer

By reading a window rather than everything after a point. Polytomic stores the previous tracking position, then reads rows greater than it and less than or equal to a fresh high water mark taken at the start of the run. Bounding the top end matters on a busy ClickHouse table, because rows arriving mid query would otherwise make the read non deterministic. The sorting key can also be used to chunk that window predictably.

Question 3

Can Polytomic create the HubSpot property?

Accepted Answer

No. Existing custom properties can be written to but property creation is not exposed, so create it in HubSpot first and then map to it. That is one extra step, and worth keeping, because it means a mistyped mapping fails cleanly rather than quietly adding stray fields to a CRM other teams depend on.

Question 4

How do associations work from a ClickHouse model?

Accepted Answer

As relationship fields. Choose the related object and the lookup property to match on, and Polytomic resolves that record and writes the association, including labelled and custom association types. So a row carrying a company domain can end up properly linked to the company. If the lookup finds nothing, that record reports an error rather than writing a broken link, which is the behaviour you want.

Question 5

What changes when the score reaches the CRM?

Accepted Answer

Which accounts get attention. A propensity score computed over event data is invisible to anyone outside the data team while it stays in a table, and asking a rep to open another tool does not survive a busy week. Reverse ETL puts it on the company record so the decision happens where the work happens, using the same definition reporting uses rather than an approximation rebuilt in HubSpot.

Sync ClickHouse to HubSpot

Sync ClickHouse to HubSpot with Polytomic

Most of the CRM is writable

Bounded incremental reads

Associations resolved

Or sync HubSpot to ClickHouse

Trusted by businesses worldwide

Step-by-step integration guide

Connect ClickHouse in Polytomic

Connect HubSpot in Polytomic

Create a sync between ClickHouse and HubSpot

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 ClickHouse with HubSpot?