v1.5.0-a1 dbt_intercom

PR #75 includes the following updates:

Schema/Data Change

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	Exposes the conversation assignee ID (the ID of the user assigned to the conversation) from the staging layer for reference and joins. If you persist assignee_id via the intercom__conversation_history_pass_through_columns variable, ensure its alias does not match conversation_assignee_id 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

Under the Hood

• 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.

Full Changelog: v1.4.0...v1.5.0-a1

v1.4.0 dbt_intercom

PR #74 includes the following updates:

Schema/Data Change

4 total changes • 0 possible breaking changes

Data Model(s)	Change type	Old	New	Notes
intercom__article_enhanced	New model			Help center articles enhanced with metadata including author details, collection hierarchy, and performance statistics
stg_intercom__article_history stg_intercom__article_history_tmp	New models			Staging models for the article_history source
stg_intercom__collection_history stg_intercom__collection_history_tmp	New models			Staging models for the collection_history source
stg_intercom__help_center_history stg_intercom__help_center_history_tmp	New models			Staging models for the help_center_history source

Feature Update

• Adds intercom__article_history_pass_through_columns variable to support custom fields in intercom__article_enhanced model
• Adds intercom__using_articles variable to enable/disable help center article models (defaults to True)
• Adds intercom__using_collection_history variable to enable/disable collection models (requires intercom__using_articles to be True)
• Adds intercom__using_help_center_history variable to enable/disable help center models (requires both intercom__using_articles and intercom__using_collection_history to be True)
  • See the README for configuration details

Under the Hood

• Adds column definition macros and integration test seed files for the new sources.
• Adds consistency test for intercom__article_enhanced.

Contributors

• @jhiza (#73)

Full Changelog: v1.3.0...v1.4.0

v1.3.0 dbt_intercom

PR #71 includes the following updates:

Feature

• Increases the required dbt version upper limit to v3.0.0.

Full Changelog: v1.2.0...v1.3.0

v1.2.0 dbt_intercom

PR #70 introduces the following updates:

Schema/Data Changes

3 total changes • 2 possible breaking changes

Data Model(s)	Change type	Old	New	Notes
All models	New column		source_relation	Identifies the source connection when using multiple Intercom connections
stg_intercom__tag	New data type	name categorized as timestamp	name categorized as string	Modifies name to its proper string format, per the Intercom docs.
stg_intercom__team stg_intercom__team_admin	New data type	team_id categorized as integer	team_id categorized as string	Modifies team_id to its proper string format, per the Intercom docs.

Feature Update

• Union Data Functionality: This release supports running the package on multiple Intercom source connections. See the README for details on how to leverage this feature.

Tests Update

• Removes uniqueness tests. The new unioning feature requires combination-of-column tests to consider the new source_relation column in addition to the existing primary key, but this is not supported across dbt versions.
• These tests will be reintroduced once a version-agnostic solution is available.

Under the Hood

• New consistency tests introduced on all end models to validate that the above changes do not impact end model values.

Full Changelog: v1.1.0...v1.2.0

v1.1.0 dbt_intercom

PR #69 includes the following updates:

Bug Fixes

• 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.

Under the Hood

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

Full Changelog: v1.0.0...v1.1.0

v1.1.0-a2 dbt_intercom

PR #68 is a pre-release that includes the following updates:

Bug Fixes

• Consolidated CTEs and joins to reduce the compute load of int_intercom__conversation_part_events for customers with large intercom__conversation_part_history source tables.
• Corrected last_close_by_author_id logic that was incorrectly referencing first_close_by_author_id values.

Under the Hood

• Created consistency test for intercom__conversation_enhanced to validate that the above changes do not impact end model values.

Full Changelog: v1.0.0...v1.1.0-a2

v1.1.0-a1 dbt_intercom

PR #67 is a pre-release that includes the following updates:

Schema Updates (--full-refresh encouraged after upgrading)

Data Model	Change Type	Old Behavior	New Behavior	Notes
int_intercom__conversation_part_events	Updated materialization	Ephemeral	Table	Reduces compute load of intercom__conversation_enhanced to prevent timeout run issues.
int_intercom__conversation_string_aggregates	Updated materialization	Ephemeral	Table	Reduces compute load of intercom__conversation_enhanced to prevent timeout run issues.
int_intercom__conversation_part_aggregates	Updated materialization	Ephemeral	Table	Reduces compute load of intercom__conversation_metrics to prevent timeout run issues.

Full Changelog: v1.0.0...v1.1.0-a1

v1.0.0 dbt_intercom

PR #66 includes the following updates:

Breaking Changes

Source Package Consolidation

• Removed the dependency on the fivetran/intercom_source package.
  • All functionality from the source package has been merged into this transformation package for improved maintainability and clarity.
  • If you reference fivetran/intercom_source in your packages.yml, you must remove this dependency to avoid conflicts.
  • Any source overrides referencing the fivetran/intercom_source package will also need to be removed or updated to reference this package.
  • Update any intercom_source-scoped variables to be scoped to only under this package. See the README for how to configure the build schema of staging models.
• As part of the consolidation, vars are no longer used to reference staging models, and only sources are represented by vars. Staging models are now referenced directly with ref() in downstream models.

dbt Fusion Compatibility Updates

• Updated package to maintain compatibility with dbt-core versions both before and after v1.10.6, which introduced a breaking change to multi-argument test syntax (e.g., unique_combination_of_columns).
• Temporarily removed unsupported tests to avoid errors and ensure smoother upgrades across different dbt-core versions. These tests will be reintroduced once a safe migration path is available.
  • Removed all dbt_utils.unique_combination_of_columns tests.
  • Removed all accepted_values tests.
  • Moved loaded_at_field: _fivetran_synced under the config: block in src_intercom.yml.

Under the Hood

• Updated conditions in .github/workflows/auto-release.yml.
• Added .github/workflows/generate-docs.yml.

Full Changelog: v0.10.0...v1.0.0

v0.10.0 dbt_intercom

PR #63 includes the following updates:

Breaking Change for dbt Core < 1.9.6

Note: This is not relevant to Fivetran Quickstart users.

Migrated freshness from a top-level source property to a source config in alignment with recent updates from dbt Core (Intercom Source v0.9.0). This will resolve the following deprecation warning that users running dbt >= 1.9.6 may have received:

[WARNING]: Deprecated functionality
Found `freshness` as a top-level property of `intercom` in file
`models/src_intercom.yml`. The `freshness` top-level property should be moved
into the `config` of `intercom`.

IMPORTANT: Users running dbt Core < 1.9.6 will not be able to utilize freshness tests in this release or any subsequent releases, as older versions of dbt will not recognize freshness as a source config and therefore not run the tests.

If you are using dbt Core < 1.9.6 and want to continue running Intercom freshness tests, please elect one of the following options:

1. (Recommended) Upgrade to dbt Core >= 1.9.6
2. Do not upgrade your installed version of the intercom package. Pin your dependency on v0.9.2 in your packages.yml file.
3. Utilize a dbt override to overwrite the package's intercom source and apply freshness via the previous release top-level property route. This will require you to copy and paste the entirety of the previous release src_intercom.yml file and add an overrides: intercom_source property.

Under the Hood

• Updates to ensure integration tests use latest version of dbt.

Full Changelog: v0.9.2...v0.10.0

v0.9.2 dbt_intercom

Documentation

• Added Quickstart model counts to README. (#55)
• Corrected references to connectors and connections in the README. (#55)

Under the Hood

• Updated the quickstart.yml file to allow for automated Quickstart data model deployments. (PR #51)
• Prepends materialized configs in the package's dbt_project.yml file with + to improve compatibility with the newer versions of dbt-core starting with v1.10.0. (PR #57)
• Updates the package maintainer pull request template. (PR #58)

Contributors

• @b-per (PR #57)

Full Changelog: v0.9.1...v0.9.2