Removal of intercom_contact_enhanced duplicate bug by creating an int_intercom__latest_contact intermediate model to select the most recent edition of the contact.
Additional logic within the int_intercom__latest_contact model is due to dbt_utils.star not working with ephemeral models. Additionally, if this logic was not applied then the latest_contact_index field would be passed through to the final model. Direct calling of fields was not done in the intercom__contact_enhanced model to allow passthrough columns to more dynamically be passed through.
ReadMe updates to make declaring variables easier to understand.
Addition of the variables to disable models to the dbt_project.yml.
CircleCi data type casting fixes.
Data type casting fix within int_intercom__conversation_part_events to properly cast the first and last close by admin fields as string. This is due to the source admin table brings the admin_id field in as a string.
Changes in this branch include:
intercom_contact_enhanced
duplicate bug by creating anint_intercom__latest_contact
intermediate model to select the most recent edition of the contact.int_intercom__latest_contact
model is due to dbt_utils.star not working with ephemeral models. Additionally, if this logic was not applied then thelatest_contact_index
field would be passed through to the final model. Direct calling of fields was not done in theintercom__contact_enhanced
model to allow passthrough columns to more dynamically be passed through.dbt_project.yml
.int_intercom__conversation_part_events
to properly cast the first and last close by admin fields as string. This is due to the sourceadmin
table brings the admin_id field in as a string.Joe PR Loom Explanation Walkthrough