Question 1

Why do batch sizes vary between tables?

Accepted Answer

Because Azure SQL limits a single statement to two thousand parameters. Polytomic sizes each batch as the lesser of a thousand rows or two thousand divided by the number of columns, so a narrow table loads a thousand rows at a time while a wide HubSpot object with sixty properties loads thirty three. It is worth knowing when a contacts sync with every property enabled runs slower than you expected.

Question 2

Is there a faster load path?

Accepted Answer

Yes, optionally. Azure SQL supports a bulk load mode that writes CSV to Azure Blob Storage and runs T-SQL BULK INSERT against it, temporarily creating a database scoped SAS credential and external data source to do so. It takes more setup than the default batched inserts but sidesteps the parameter limit entirely, which is the thing that slows wide tables down.

Question 3

Can I get deal stage history?

Accepted Answer

Yes. Contact, company and deal property history each arrive as their own table, one row per change carrying the object ID, property name, new value, timestamp, source and the user responsible. That is the shape stage duration analysis needs and the HubSpot interface will not give you.

Question 4

How does the incremental read work?

Accepted Answer

The first ETL run scans HubSpot's list API in full. After that Polytomic searches on lastmodifieddate, collects the IDs that changed, then batch reads the properties you selected. Runs overlap their lookback windows and deduplicate, because HubSpot's search index lags slightly behind its own writes.

Question 5

Do HubSpot deletions reach Azure SQL?

Accepted Answer

Not through the incremental path, since the search API only returns records that still exist. A periodic full resync marks the missing rows through the deleted at column, or hard delete propagation removes them outright. There is also a newer feature gated option to include archived HubSpot records worth asking about.

Sync HubSpot to Azure SQL

Sync HubSpot to Azure SQL with Polytomic

Batches sized by width

Property history included

Custom properties found

Or sync Azure SQL to HubSpot

Trusted by businesses worldwide

Step-by-step integration guide

Connect HubSpot in Polytomic

Connect Azure SQL in Polytomic

Create a sync between HubSpot and Azure SQL

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 Azure SQL?