search

fivetran / dbt_zendesk

Fivetran's Zendesk Support dbt package
https://fivetran.github.io/dbt_zendesk/#!/overview
Apache License 2.0
26 stars 30 forks source link

[Feature] "pausable_update_time" in ticket_field_history.field_name #168

Open dfberdoy opened 2 months ago

dfberdoy commented 2 months ago

Hi Team, I'm just wondering if is possible somehow to include "pausable_update_time" in this filter:

https://github.com/fivetran/dbt_zendesk/blob/66d7b7c2f991e89a94906e8b4076cd04ce91e089/models/sla_policy/int_zendesk__sla_policy_applied.sql#L40

or if there is a workaround to avoid filtering out those cases

Thank you!

fivetran-catfritz commented 2 months ago

Hi @dfberdoy thanks for opening up this ticket. Are you looking to use int_zendesk__sla_policy_applied directly or would you ultimately want pausable_update_time persisted through to model zendesk__sla_policies? The reason we don't include pausable_update_time is because we haven't built out support for it in the downstream models, so I'm curious to hear how you're using this metric!

fivetran-catfritz commented 1 month ago

Hi @dfberdoy I am going to mark this as a feature request and will leave this issue open in case anyone else wants to chime with interest or input on this feature!