Deleted Conversation Tags and Contact Tags Still Appear as Active in the Destination

Issue

Conversation tags and contact tags still appear as active in the destination after they are deleted in Intercom.

Environment

Connector: Intercom

Resolution

To identify deleted contact tags, run the following query:

SELECT * FROM RAW_DB.INTERCOM.CONTACT_TAG_HISTORY a
JOIN RAW_DB.INTERCOM.CONTACT_HISTORY b
ON a.contact_id = b.id
WHERE
b._fivetran_active = TRUE
AND b._fivetran_start > a._fivetran_start
LIMIT 10

To identify deleted conversation tags, run the following query:

SELECT * FROM RAW_DB.INTERCOM.CONVERSATION_TAG_HISTORY a
JOIN RAW_DB.INTERCOM.CONVERSATION_HISTORY b
ON a.conversation_id = b.id
WHERE
b._fivetran_active = TRUE
AND b._fivetran_start > a._fivetran_start
LIMIT 10

These queries return tag history records where the associated contact or conversation has a newer active version, indicating that the tag was removed.

Cause

Fivetran doesn't support delete capture for the CONVERSATION_TAG_HISTORY and CONTACT_TAG_HISTORY tables. As a result, when tags are removed from conversations or contacts in Intercom, those removals aren't reflected in the destination, and the tags continue to appear as active.