adds discounts! to a new final model and aggregates them in shopify__orders
what i still need to do:
[x] document this new model. I'll do this as the first review of this PR is happening (if that works for you joe)
[x] incorporate the same logic for refunds and adjustments into the the staging discount_code model (ie create empty ones if the source tables don't exist) however, before i did this, i wanted to ask @fivetran-joemarkiewicz if we should should do this across the board in every tmp model...? 🤔
Did you update the CHANGELOG?
[ ] Yes
no, will be done in the documentation PR
Does this PR introduce a breaking change?
[ ] Yes (please provide breaking change details below.)
[x] No (please provide an explanation as to how the change is non-breaking below.)
Is this PR in response to a previously created Bug or Feature Request
[ ] Yes, Issue/Feature [link bug/feature number here]
[X] No but came up on customer calls
How did you test the PR changes?
[x] Buildkite
[x] Local (please provide additional testing details below)
Select which warehouse(s) were used to test the PR
[x] BigQuery
[x] Redshift
[x] Snowflake
[x] Postgres
[x] Databricks
[ ] Other (provide details below)
Provide an emoji that best describes your current mood
âš¡
**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.
Are you a current Fivetran customer?
fivetran made PR
What change(s) does this PR introduce?
adds discounts! to a new final model and aggregates them in shopify__orders
what i still need to do:
Did you update the CHANGELOG?
Does this PR introduce a breaking change?
Is this PR in response to a previously created Bug or Feature Request
How did you test the PR changes?
Select which warehouse(s) were used to test the PR
Provide an emoji that best describes your current mood
âš¡ **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.