fivetran / dbt_jira

Data models for Fivetran's Jira connector built using dbt.
https://fivetran.github.io/dbt_jira/
Apache License 2.0
8 stars 13 forks source link

Add incremental logic to issue_history_scd cte #113

Open jschintz-windriver opened 9 months ago

jschintz-windriver commented 9 months ago

Please provide your name and company

Link the issue/feature request which this PR is meant to address https://github.com/fivetran/dbt_jira/issues/111

Detail what changes this PR introduces and how this addresses the issue/feature request linked above. Adds incremental logic to models/intermediate/field_history/int_jira__issue_calendar_spine.sql to reduce the amount of data that needs to be updated. How did you validate the changes introduced within this PR? Ran forked repo with snowflake DW. Which warehouse did you use to develop these changes? Snowflake Did you update the CHANGELOG?

Did you update the dbt_project.yml files with the version upgrade (please leverage standard semantic versioning)? (In both your main project and integration_tests)

Provide an emoji that best describes your current mood

:dancer: **Feedback** We are so excited you decided to contribute to the Fivetran community dbt package! We continue to work to improve the packages and would greatly appreciate your [feedback](https://www.surveymonkey.com/r/DQ7K7WW) on our existing dbt packages or what you'd like to see next. **PR Template** - [Community Pull Request Template](?expand=1&template=pull_request_template.md) (default) - [Maintainer Pull Request Template](?expand=1&template=maintainer_pull_request_template.md) (to be used by maintainers)