hubspot

RAW.POLYTOMIC_HUBSPOT — Schema Profile

Source: HubSpot via Polytomic
Profiled: 2026-03-02

---

Tables

Table	Rows	Last Altered	Grain
DEAL_PROPERTY_HISTORY	63,199	2026-03-02	One row per deal + property + change
COMPANY_PROPERTY_HISTORY	356,153	2026-03-02	One row per company + property + change

---

Schema (Both Tables)

Column	Type	Notes
DEAL_ID / COMPANY_ID	TEXT	Entity ID
PROPERTY_NAME	TEXT	HubSpot property name
SOURCE_ID	TEXT	Source of change
SOURCE_TYPE	TEXT	e.g. CRM_UI, INTERNAL_PROCESSING, CALCULATED
TIMESTAMP	TEXT	ISO-8601 when property changed
UPDATED_BY_USER_ID	TEXT	User who made change (if applicable)
VALUE	TEXT	New value (string)
POLYTOMIC*	—	Polytomic metadata

---

DEAL_PROPERTY_HISTORY

• Distinct properties: 283
• Key properties (examples): dealname, dealstage, amount, closedate, createdate, dealtype, deal_source, deal_priority, hs_is_closed, hs_is_closed_won
• Pivot required: To get current deal state, use MAX(TIMESTAMP) per DEAL_ID + PROPERTY_NAME and pivot, or use LAST_VALUE(VALUE) OVER (PARTITION BY DEAL_ID, PROPERTY_NAME ORDER BY TIMESTAMP)

---

COMPANY_PROPERTY_HISTORY

• Distinct properties: 170
• Key properties (examples): domain, name, createdate, annualrevenue, address, country, city, industry, hs_is_contact

---

Staging Model Guidance

1. History → current state: Pivot or window to get latest value per entity per property
2. TIMESTAMP: Cast to TIMESTAMP for date filters
3. VALUE: May be numeric, date, or string — cast as needed per property
4. Deals for revenue: Join amount, closedate, dealstage for pipeline/revenue views