Click here to learn about Tableau, Power BI, and MS Excel templates for HubSpot.
Tables
Pre-mapped ETL+ tables available for HubSpot. Subject to change without notice.
Important: DataSelf DFT foundation is ERP agnostic - click here to learn more.
|
Source |
Table Name |
|---|---|
|
HubSpot |
Companies |
|
HubSpot |
Contacts |
|
HubSpot |
DealProperties |
|
HubSpot |
Deals |
|
HubSpot |
DealProperties |
|
HubSpot |
Domains |
|
HubSpot |
EmailCampaignEvents |
|
HubSpot |
EmailCampaign |
|
HubSpot |
Engagements |
|
HubSpot |
Owners |
|
HubSpot |
TicketProperties |
|
HubSpot |
Tickets |
|
Data Warehouse |
4_Today |
|
Data Warehouse |
5_Date |
|
Data Warehouse |
6_DatePeriod |
Notes:
-
Some of the above tables will only be deployed using customized SOWs or via services.
-
Currently, the HubSpot tables can be extracted into the data warehouse using ODBC.
-
We only recommend extracting tables that are important for your reporting purposes.
Table Columns Example
DataSelf ETL+ templates include adjustments to table columns' data types and indexes. Click here to learn more.
The following is an example of a HubSpot table and its column names, indexes, and formatting in ETL+.
Delta Load Example
DataSelf ETL+ templates include delta load configuration for popular large tables. This dramatically reduces the time to refresh the data warehouse. ETL+ Table Load Types.
The following is an example using the Upsert feature.
