CONNECTOR · HUBSPOT

HubSpot — Contacts, companies, deals, engagements. Treat as a CRM-of-record source.

CONNECTOR · HUBSPOT

HubSpot

Contacts, companies, deals, engagements. Treat as a CRM-of-record source.

categorySource · CRM
freshness targetHourly batch.
auth modelPrivate app access token.
sync modeInitial backfill + incremental on lastmodifieddate.

TABLES SYNCED

contacts, companies, deals, engagements, tickets.

SCHEMA · SAMPLE

schema.sqlSQL

CREATE TABLE hubspot.deals (
  id              TEXT PRIMARY KEY,
  dealstage       TEXT,
  amount          NUMERIC,
  closedate       TIMESTAMP,
  hs_object_source TEXT
);

QUERY · SAMPLE

query.sqlSQL

SELECT dealstage, COUNT(*) AS deals, SUM(amount) AS pipeline
FROM hubspot.deals
WHERE closedate >= now() - interval 0
GROUP BY 1 ORDER BY 3 DESC;

OPS NOTES

HubSpot's 'lastmodifieddate' is timezone-naive. Normalize to UTC at staging or expect 1-hour drift around DST.

RELATED · CONNECTORS

Source · OLTP

Postgres

Destination · Warehouse

Snowflake

Destination · Warehouse

BigQuery

Source · Event tracking

Segment

Wire a real pipeline to your warehouse

30-min stack review. We come back with a scoped plan, an owner, and a freshness contract. No SDR, no slide deck.

Book a 30-min review Open the playground