This PR will address the following Issue/Feature: N/A This is for the downstream PR in dbt_zendesk
This PR will result in the following new package version:v0.11.0
This will be breaking as this has potential to change downstream metrics. In particular there may be some warehouses that treat the timezone timestamps differently. This update ensures all timestamps are non timezone.
Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:
Bug Fixes
Updated the following staging models to leverage the {{ dbt.type_timestamp() }} macro on timestamp fields in order to ensure timestamp with no timezone is used in downstream models.
stg_zendesk__ticket
stg_zendesk__ticket_comment
stg_zendesk__ticket_field_history
stg_zendesk__ticket_form_history
stg_zendesk__ticket_schedule
stg_zendesk__time_zone
stg_zendesk__user
PR Checklist
Basic Validation
Please acknowledge that you have successfully performed the following commands locally:
[x] dbt run –full-refresh && dbt test
[x] dbt run (if incremental models are present) && dbt test
Before marking this PR as "ready for review" the following have been applied:
[X] The appropriate issue has been linked, tagged, and properly assigned
[X] All necessary documentation and version upgrades have been applied
[X] docs were regenerated (unless this PR does not include any code or yml updates)
[X] BuildKite integration tests are passing
[X] Detailed validation steps have been provided below
Detailed Validation
Please share any and all of your validation steps:
I don't feel there are many more validation steps necessary for this PR. The validation of the dbt_zendesk PR should be sufficient.
If you had to summarize this PR in an emoji, which would it be?
PR Overview
This PR will address the following Issue/Feature: N/A This is for the downstream PR in dbt_zendesk
This PR will result in the following new package version:
v0.11.0This will be breaking as this has potential to change downstream metrics. In particular there may be some warehouses that treat the timezone timestamps differently. This update ensures all timestamps are non timezone.
Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:
Bug Fixes
{{ dbt.type_timestamp() }}macro on timestamp fields in order to ensure timestamp with no timezone is used in downstream models.stg_zendesk__ticketstg_zendesk__ticket_commentstg_zendesk__ticket_field_historystg_zendesk__ticket_form_historystg_zendesk__ticket_schedulestg_zendesk__time_zonestg_zendesk__userPR Checklist
Basic Validation
Please acknowledge that you have successfully performed the following commands locally:
Before marking this PR as "ready for review" the following have been applied:
Detailed Validation
Please share any and all of your validation steps:
I don't feel there are many more validation steps necessary for this PR. The validation of the dbt_zendesk PR should be sufficient.
If you had to summarize this PR in an emoji, which would it be?
⏲️