v0.16.0 dbt_zendesk
fivetran-data-model-bot
released this
15 May 15:26
·
1 commit
to main
since this release
🚨 Minor Upgrade 🚨
Although this update is not a breaking change, it will likely impact the output of the zendesk__sla_policies
and zendesk__sla_metrics
models. PR #154 includes the following changes:
Bug Fixes
- Addresses the potential issue where the
first_reply_time_business_minutes
metric within thezendesk__ticket_metrics
model would incorrectly calculate the elapsed time when daylight savings occurred. This change involved adjusting a join to reference the difference of two dates as opposed to timestamps. This more accurately applies a cutoff event during daylight savings. - Introduction of an additional condition within the
filtered_reply_times
cte of theint_zendesk__reply_time_combined
model to ensure tickets replied to before any schedule begins and no business minutes have been spent is reserved for only the first day the ticket is open. Previously, this condition could be met on days other than the first. This would potentially result in duplicates ofsla_event_id
's further downstream in thezendesk__sla_policies
model.
Under the Hood
- Addition of integrity and consistency validation tests within integration tests for the
zendesk__sla_policies
andzendesk__ticket_metrics
models.
Full Changelog: v0.15.0...v0.16.0