This PR adds the ability for the dbt package to reference a new fivetran_formula_model source table that will include the entire select statement instead of just the pieces of the formulas. If using this new full_statement_version argument, then the package will just grab the statement from the fivetran_formula_model and materialize it within the warehouse.
Did you update the CHANGELOG?
[ ] Yes
Does this PR introduce a breaking change?
[X] Yes (please provide breaking change details below.)
[ ] No (please provide an explanation as to how the change is non-breaking below.)
This actually will not be a breaking change. However, I feel it warrants a breaking change as it is a significant feature.
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)
[X] Yes
Is this PR in response to a previously created Bug or Feature Request
[ ] Yes, Issue/Feature [link bug/feature number here]
[X] No
How did you test the PR changes?
[X] CircleCi
[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
[ ] 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 created PR
What change(s) does this PR introduce?
This PR adds the ability for the dbt package to reference a new
fivetran_formula_modelsource table that will include the entire select statement instead of just the pieces of the formulas. If using this newfull_statement_versionargument, then the package will just grab the statement from thefivetran_formula_modeland materialize it within the warehouse.Did you update the CHANGELOG?
Does this PR introduce a breaking change?
This actually will not be a breaking change. However, I feel it warrants a breaking change as it is a significant feature.
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)
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.