Question 1

What can I write from BigQuery into HubSpot?

Accepted Answer

Companies, contacts, deals, tickets, products and line items, activities such as calls, meetings, emails, notes and tasks, and also invoices, services, custom objects, static lists and custom behavioural events. That is a wide surface, so you can put an account health score on a company, log product milestones as events, or keep a static list matching a model in your data warehouse.

Question 2

Will Polytomic create HubSpot properties for me?

Accepted Answer

No. Existing custom properties can be written to, but property creation is not exposed, so create the property in HubSpot first and then map to it. It is one extra step and worth building into your process, since it means a mistyped mapping fails cleanly rather than quietly littering your CRM with stray fields nobody meant to make.

Question 3

How do HubSpot associations work from a BigQuery model?

Accepted Answer

They are mapped as relationship fields. You choose the related object and the lookup property to match on, and Polytomic resolves the record and writes the association, including labelled and custom association types. So a deal row in your model can carry a company domain and end up properly linked. If the lookup finds nothing, that record reports an error rather than writing a broken link, which is the behaviour you want.

Question 4

How does Polytomic read the BigQuery model for each sync?

Accepted Answer

It runs your table selection or custom SQL as a BigQuery query and reads the results, using the Storage Read API by default because it is faster than pulling rows over REST. Some cases fall back to the slower REST reader automatically, including external tables, materialized views, and setups where the read sessions permission is missing. That fallback is transparent and should not fail the sync, though it will be slower on a large model.

Question 5

Why not just let sales query the data warehouse directly?

Accepted Answer

Because they will not, and it is unreasonable to expect it. Reps work in the CRM all day and a number that requires opening another tool is a number nobody looks at. Putting a health score or usage figure directly on the company record changes which accounts get called this week, which a dashboard never does. Reverse ETL is the mechanism, but the real point is meeting people in the tool they already have open.

Sync BigQuery to HubSpot

Sync BigQuery to HubSpot with Polytomic

Most of the CRM is writable

Associations resolved

Differential by default

Or sync HubSpot to BigQuery

Trusted by businesses worldwide

Step-by-step integration guide

Connect BigQuery in Polytomic

Connect HubSpot in Polytomic

Create a sync between BigQuery 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 BigQuery with HubSpot?