Question 1

What HubSpot data can I load into BigQuery?

Accepted Answer

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

Question 2

What happens in BigQuery when someone edits a HubSpot property?

Accepted Answer

Adding a property is easy, since new source columns are picked up and added to the table automatically. Two behaviours are worth knowing beyond that. A property deleted in HubSpot is not removed from BigQuery, so the column stays until you clear it yourself. And if a property changes to a type that does not fit the existing column, the old column is renamed with its previous type appended and a fresh column takes the original name, so nothing breaks and no history is lost.

Question 3

How does Polytomic keep HubSpot data current in BigQuery?

Accepted Answer

For the main CRM objects, the HubSpot search API finds records changed since the last run by last modified date, then a batch read collects the full properties and associations for those records. Those load into a temporary table and merge into the destination on your key. The very first load uses the list API instead, since there is nothing to compare against yet. Some event style datasets carry their own timestamp cursors rather than going through search.

Question 4

Are deleted HubSpot records removed from BigQuery?

Accepted Answer

Not by incremental runs, and this is worth designing around early. HubSpot's incremental API does not report deletions, so a record removed in HubSpot will not be flagged in BigQuery by a normal run. The ways round it are full refresh mode, or periodic full resyncs so reconciliation clears rows that are no longer there. A few entity types do expose an archived or deleted timestamp, but that is not general delete tracking across the CRM.

Question 5

Why load HubSpot into BigQuery?

Accepted Answer

For history and for joins. HubSpot shows current state well, but nothing in it records what a deal was worth three months ago in a way you can query, so questions about how a quarter actually developed are awkward to answer from the CRM. ETL into a data warehouse gives you that history at whatever grain you want, and puts CRM records beside product usage, billing and support data so the joins people keep asking for become ordinary SQL.

Sync HubSpot to BigQuery

Sync HubSpot to BigQuery with Polytomic

Property history included

Custom properties found

Property changes absorbed

Or sync BigQuery to HubSpot

Trusted by businesses worldwide

Step-by-step integration guide

Connect HubSpot in Polytomic

Connect BigQuery in Polytomic

Create a sync between HubSpot and BigQuery

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 BigQuery?