[Feature] Incoprorate Historical Schedule Changes

fivetran-jamie commented 3 months ago

Is there an existing feature request for this?

[X] I have searched the existing issues

Describe the Feature

Account for changes made to schedule start/end times by using the audit_log source table. Work has been started in https://github.com/fivetran/dbt_zendesk/pull/157 and https://github.com/fivetran/dbt_zendesk_source/pull/50 but the logic in the schedule_spine model needs to be updated to include the new code

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

[X] Yes.
[ ] Yes, but I will need assistance and will schedule time during your office hours for guidance.
[ ] No.

Anything else?

No response

dkang1023 commented 2 months ago

@fivetran-jamie Hi Jamie, we are a Fivetran customer and looking to rely on this feature for critical business reporting. What's the current status of this, and are we able to get this prioritized? Let me know and thank you so much.

fivetran-joemarkiewicz commented 2 months ago

Hi @dkang1023 we are actually committing to this as a feature update in our upcoming quarter (starting next week). I estimate we will have a working version ready by mid September.

dkang1023 commented 3 weeks ago

Hi @fivetran-joemarkiewicz - I wanted to check-in here and confirm we should expect a fix in the upcoming weeks in September? Let me know and thanks again.

fivetran-catfritz commented 3 weeks ago

Hi @dkang1023 I will picking up this ticket. The updates are a bit complex, so the goal is to have this finished around the end of September!

fivetran / dbt_zendesk