CRM & Sales
HubSpot schema
SightShark syncs HubSpot into a data warehouse you own. It creates 3 tables holding 25 fields, refreshed daily. Deals, contacts and companies from the CRM API.
3 tables / 25 fields / Provisional
Provisional
The table names below follow this site’s naming convention rather than a production sync, and the field names follow the documented HubSpot schema. Confirm both against your own dataset before you rely on them.
Tables and fields
Every table this connector creates. Field lists come from the production sync where we publish it, and otherwise from the documented schema, marked on the table.
hubspot_deals
8 fields
- deal_id
- deal_name
- deal_stage
- pipeline
- amount
- close_date
- created_at
- probability
hubspot_contacts
5 fields
- contact_id
- lifecycle_stage
- original_source
- created_at
hubspot_companies
12 fields, documented schema
- company_id
- is_company_deleted
- company_name
- description
- created_date
- industry
- street_address
- street_address_2
- city
- state
- country
- company_annual_revenue
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Revenue lives in the CRM and spend lives in the ad platforms, so nobody can put cost and closed revenue in one table without exporting both by hand.
Questions people ask
What tables does SightShark create from HubSpot?
3 tables, including hubspot_deals, hubspot_contacts, hubspot_companies. hubspot_deals is one row per deal. Every one is listed on this page, with its fields.
Which HubSpot fields can I get?
The 25 fields on this page, table by table. Lists marked documented schema follow the published schema for HubSpot, and your own warehouse may carry a few more or fewer.
How often does HubSpot data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join HubSpot data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across HubSpot and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 7 min read
What it takes to build a unified customer view for a client.
Four systems each hold part of a person. Joining them up is a keys problem, not a tooling problem.
Read it - 6 min read
How AI agents actually read client marketing data.
Giving an agent access is the easy half. Giving it something it can answer from is the work.
Read it - 6 min read
What a first-party data strategy actually involves.
Less a strategy than an inventory, a home and a set of permissions.
Read it
Get started
Want HubSpot in your own warehouse?
A call with someone who can answer the schema questions.