Release Notes

August 2026

2 total changes • 1 possible breaking change

Data Model(s)	Change type	Old	New	Notes
(Breaking) `stg_intercom__tag`, `stg_intercom__company_tag_history`, `stg_intercom__contact_tag_history`, `stg_intercom__conversation_tag_history`	Changed data type	integer	string	Casts `tag_id` as a string so joins succeed regardless of source type.
`stg_intercom__company_history`, `stg_intercom__company_tag_history`, `stg_intercom__contact_company_history`	explicit data type cast	source data type	string	Casts `company_id` as a string for consistent join keys.

Resolves a Database Error in intercom__company_enhanced (and other tag-joined models) caused by mismatched tag_id data types. The fix casts all ID join keys to string in staging. See the Schema/Data Change table above.

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.

3 total changes • 2 possible breaking change

Data Model(s)	Change type	Old	New	Notes
`intercom__conversation_enhanced` `intercom__conversation_metrics`	New field		`conversation_assignee_id`	The ID of the user assigned to the conversation. This column is an alias of `assignee_id` from `stg_intercom__conversation_history` model. If you also persist `assignee_id` using the `intercom__conversation_history_pass_through_columns` variable, ensure it uses a different alias to avoid duplicate column errors.
`intercom__conversation_enhanced` `intercom__conversation_metrics`	New field		`is_assignee_admin`	Boolean field indicating whether the conversation assignee is an admin user, determined by joining `assignee_id` with the admin table. Returns `false` if conversation is unassigned or assigned to a non-admin user
`intercom__conversation_enhanced` `intercom__conversation_metrics` `stg_intercom__conversation_history`	Deprecated field	`assignee_type` or `conversation_assignee_type`	Marked as [DEPRECATED]	The `assignee_type` field is no longer supported by Intercom's API. Use `is_assignee_admin` instead to determine if an assignee is an admin

Updated intercom__admin_metrics to filter conversations using is_assignee_admin boolean instead of the deprecated conversation_assignee_type = 'admin' string comparison
Enhanced intercom__conversation_enhanced with a left join to the admin table to determine admin assignee status
Updates to the integrity and consistency validation tests to ensure accurate testing of model changes between versions.

In the quickstart.yml file:
- Adds table_variables for relevant sources to prevent missing sources from blocking downstream Quickstart models.
- Adds supported_vars for Quickstart UI customization.

Performance optimization: Refactored int_intercom__conversation_part_events for customers with large intercom__conversation_part_history source tables:
- Consolidated redundant CTEs and eliminated unnecessary joins to reduce compute load and memory usage for larger source tables.
- Implemented single window function pass instead of multiple subqueries.
- Replicate IGNORE NULLS logic with first_value() window functions using custom ordering (case when condition then 0 else 1 end) to prioritize relevant events and naturally skip null values.
Data accuracy fix: Corrected the last_close_by_author_id window function logic that was incorrectly using ascending order instead of descending order, causing it to return the same value as first_close_by_author_id. The fix ensures proper chronological ordering to capture the actual last close event author.

Created consistency and integrity tests for intercom__conversation_enhanced to validate that the above changes do not impact end model values.