Release Notes

August 2026

We've updated the following quickstart data model packages to add DuckDB as a supported destination:

In v1.9.1, we fixed a compilation error in hubspot__conversations when either variable hubspot_team_enabled or hubspot_role_enabled is set to false.

We've made the following changes in v1.9.0:

• Added the hubspot__contact_property_history_columns variable to pivot out additional properties as string columns in hubspot__daily_contact_history. See the README for configuration details.
• Added the hubspot__deal_property_history_columns variable to pivot out additional properties as string columns in hubspot__daily_deal_history. See the README for configuration details.
• Added the hubspot__company_property_history_columns variable to pivot out additional properties as string columns in hubspot__daily_company_history. See the README for configuration details.
• Added the deal_history_extension_days variable to limit or extend the history of deals in hubspot__daily_deal_history past their close dates (default=30 days). See the README for configuration details.
• Added the hubspot__daily_history_start_date variable to limit daily history models to a specific start date, reducing build time for large datasets. Applies to hubspot__daily_contact_history, hubspot__daily_deal_history, hubspot__daily_company_history, and hubspot__daily_ticket_history. See the README for configuration details.
• Added a configurable lookback_window variable to all incremental windows to catch late-arriving records. Default value = 3 days. See the README for configuration details.
• Added the hubspot_marketing_event_custom_properties variable to pivot custom property values from marketing_event_custom_property into columns in hubspot__marketing_event_performance. Set to a list of property names (e.g. ['spent', 'budget']); defaults to [] (no properties pivoted). See the README for details.
• Added the hubspot__company_list_pass_through_columns variable to bring additional columns from the company_list source table through to hubspot__company_lists and stg_hubspot__company_list. See the README for configuration details.
• Added the hubspot__contact_list_pass_through_columns variable to bring additional columns from the contact_list source table through to hubspot__contact_lists and stg_hubspot__contact_list. See the README for configuration details.
• The hubspot__pass_through_all_columns and hubspot__enable_all_property_labels variables now also apply to company_list and contact_list models.
• Cast form_id and/or conversion_id as strings when missing from source data in stg_hubspot__form and stg_hubspot__contact_form_submission.
• Ensured user_id is an integer in stg_hubspot__users when missing from source data.
• Optimized int_hubspot__ticket_calendar_spine by limiting how far into the future it looks (one day vs one week) and its start date on incremental runs. This will require a --full-refresh run.
• We've made 46 schema/data changes in v1.9.0 (0 possible breaking changes):

  Data Model(s)	Change type	Old	New	Notes
  hubspot__daily_contact_history	New end model			Each record represents a contact's state on a given day with lifecycle stage, owner, and other selected properties pivoted into columns. Contains daily engagement and email event metrics as well.
  hubspot__daily_deal_history	New end model			Each record represents a deal's state on a given day with pipeline, stage, amount, owner, team, daily engagement metrics, and other selected properties pivoted into columns.
  hubspot__daily_company_history	New end model			Each record represents a company's state on a given day with owner, lifecycle stage, daily engagement metrics, and other selected properties pivoted into columns.
  hubspot__company_lists	New end model			Each record represents a company list in HubSpot, enriched with engagement metrics aggregated across member companies. Self-managed dbt projects can disable by setting the hubspot_company_list_enabled variable to False (README).
  hubspot__conversations	New end model			One record per conversation thread, enriched with inbox, channel, channel account details, and aggregated message metrics. Dynamically enabled in Quickstart. Self-managed dbt projects can disable by setting the hubspot_conversation_enabled variable to False (README).
  hubspot__marketing_event_performance	New end model			Each record represents a marketing event with aggregated attendance metrics, contact-level participation counts, segment list membership, and optional pivoted custom properties. Self-managed dbt projects can disable the entire model by setting the hubspot_marketing_event_enabled variable to False and child table transformations with hubspot_marketing_event_list_enabled, hubspot_marketing_event_participant_enabled, and hubspot_marketing_event_custom_property_enabled (README).
  hubspot__contacts	New fields		calculated_first_conversion_fields_responded_to calculated_most_recent_conversion_fields_responded_to calculated_first_conversion_total_responses calculated_most_recent_conversion_total_responses	Comma-separated list and count of fields submitted during the contact's first and most recent form conversions. Self-managed dbt projects can disable by setting the hubspot_submission_response_enabled variable to False (README).
  stg_hubspot__conversation_thread stg_hubspot__conversation_message_history stg_hubspot__conversation_message_recipient stg_hubspot__conversation_actor stg_hubspot__conversation_channel stg_hubspot__conversation_channel_account stg_hubspot__conversation_inbox stg_hubspot__submission_response stg_hubspot__company_list stg_hubspot__company_list_member stg_hubspot__marketing_event stg_hubspot__marketing_event_list stg_hubspot__marketing_event_participant stg_hubspot__marketing_event_custom_property	New staging models (and *_tmp counterparts)			Used to power the above new end models.
  int_hubspot__daily_deal_history int_hubspot__deal_calendar_spine int_hubspot__pivot_daily_deal_history int_hubspot__scd_daily_deal_history int_hubspot__daily_contact_history int_hubspot__contact_calendar_spine int_hubspot__pivot_daily_contact_history int_hubspot__scd_daily_contact_history int_hubspot__daily_company_history int_hubspot__company_calendar_spine int_hubspot__pivot_daily_company_history int_hubspot__scd_daily_company_history	New intermediate models			Used to power new daily property history end models.
  stg_hubspot__deal_property_history stg_hubspot__company_property_history stg_hubspot__contact_property_history	New staging columns		_fivetran_start, _fivetran_end, _fivetran_active	SCD metadata fields used to power daily history models.

June 2026

v1.8.0

Under the Hood

• Migrates the union_connections, apply_source_relation, and partition_by_source_relation macros to the dbt_fivetran_utils package.
• Adds the fivetran_using_source_casing variable for case-sensitive destination support. When enabled, downstream transformations respect source casing to ensure consistent results. See the Additional Configurations section of the README for details.

March 2026

v1.7.2

Schema/Data Change

1 total change • 0 possible breaking changes

February 2026

v1.7.1

Feature Update

• Optimizes the merge_contacts() macro for Databricks destinations.

v1.7.0

Schema/Data Changes

4 total changes • 4 possible breaking changes

Under the Hood

• Updates engagements_joined macro to remove all coalesce logic to remove sunset columns.
• Brought seed column types in integration_tests/dbt_project.yml up to date to resolve runtime warnings.

Documentation Update

• Removes documentation for above sunset fields in the above models.

January 2026

v1.6.1

Test Fixes

• Removes duplicate column definitions in YAML schema files to avoid dbt parse warnings.
• Corrects descriptions for several fields.

v1.6.0

Documentation

• Updates README with standardized Fivetran formatting.

Under the Hood

• In the quickstart.yml file:
  • Adds supported_vars for Quickstart UI customization.

v1.5.0

Schema/Data Changes

3 total changes • 1 possible breaking changes

Under the Hood

• Updates seeds and macros to support the schema changes.

November 2025

v1.2.0

Schema/Data Change

5 total changes • 2 possible breaking changes

Bug Fix

• Fixes join condition in hubspot__email_sends model to include both email_send_id and email_campaign_id when joining with unsubscribes data, preventing potential data integrity issues with duplicate email send IDs across different campaigns.

Under the Hood

• Updates join logic in the add_property_labels macro to join PROPERTY and PROPERTY_OPTION on hubspot_object instead of _fivetran_id/property_id. This is used in the following staging models:
  • stg_hubspot__company
  • stg_hubspot__contact
  • stg_hubspot__deal
  • stg_hubspot__ticket
• Updates get_property_option_columns macro to include the new hubspot_object and name columns for property options.
• Updates uniqueness tests in int_hubspot__email_aggregate_status_change to use the new unique_key field instead of email_send_id.
• Updates documentation in staging models to reflect the deprecated status of _fivetran_id and property_id fields and explain the new composite primary key structure.
• Updates property_option seed data to include the newly added columns.
• Adds consistency data validation tests for hubspot__companies.