[HubSpot, HubSpot, is an inbound marketing and sales software that helps companies attract visitors, convert leads, and close customers., Features, Featurexa0Namexa0xa0xa0xa0, Supported, Notes, Capture Deletes, check, COMPANY , CONTACT , CONTACT_LIST , CONTACT_LIST_MEMBER , DEAL , DEAL_PIPELINE , DEAL_PIPELINE_STAGE and , FORM, tables., Custom Data, check, COMPANY , CONTACT , DEAL , LINE ITEMS and , PRODUCT, tables only, Data Blocking, check, Table level, Column Hashing, Re-sync, check, Connector level, History, API Configurable, check, Priority-first sync, dbt Package, check, Get the package: , source, / , model, Supported products, Product Name, HubSpot CRM, Marketing Hub, Sales Hub, Service Hub, Setup guide, Follow our , step-by-step HubSpot setup guide, to connect HubSpot with your destination using Fivetran connectors., Schema information, Marketing Hub Schema, This schema is applicable for the HubSpot Marketing Hub product., To zoom, open ERD in new window, CRM and Sales Hub Schema, This schema is applicable for the HubSpot CRM and Sales Hub products., To zoom, open ERD in new window, Service Hub Schema, This schema is applicable for the HubSpot Service Hub product., To zoom, open ERD in new window, Deleted Rows, “The HubSpot API doesnt make deleted records available so Fivetran cant mark deleted records in the destination warehouse. Deleted records will remain marked “, false, where , is_deleted, or , _fivetran_deleted, columns exist except for the tables listed in the Update Frequency section below., Update Frequency, The HubSpot API does not offer a mechanism to capture deletes, so Fivetran infers deletes for the following tables:, CONTACT_LIST, and , CONTACT_LIST_MEMBER, tables are re-imported in full once a day, DEAL_PIPELINE , DEAL_PIPELINE_STAGE and , FORM, tables are synced incrementally in each sync , We compare the tables with their previous version and capture deletes using the , _fivetran_deleted, system column., We mark the tables that we re-import in full as , not recommended, in the dashboard. We sync the tables once a day due to their non-incremental characteristics., HubSpot Developer Preview API, We maintain the following tables using the HubSpot developer preview API, so there are sometimes structural changes in these tables. Fivetran automatically handles structural changes, which might lead to some schema breaking changes. If that happens, we need to re-sync the affected tables. You can read more in the , HubSpot Developer Preview API documentation, ., LINE_ITEM, LINE_ITEM_PROPERTY_HISTORY, PRODUCT, PRODUCT_PROPERTY_HISTORY, Negative Timestamps from HubSpot, We automatically convert negative timestamps received from HubSpot to EPOCH, for example, 1st January 1970 00:00:00 UTC.]