This release introduces a new cross-db macro - get_array_to_string - to harmonise array to string transformations, as well as adds more features / optimisations to some of the existing macros. There are some automations and simplifications made under the hood for easier maintenance and clarity.
Features
Get string agg optimisations
Add get_array_to_string macro
Fix unnest macro for Postgres and snowflake (Close #105)
Add delimiter parameter to get_split_to_array (Close #106)
Tidy macro inheritance
Add warning for no data returned for model limits
Document macros in yaml, add new macro, prepare to depeciate
Add action for generating docs for pages
Checklist
[x] I have verified that these changes work locally
[x] I have updated the README.md (if applicable)
[x] I have added tests & descriptions to my models (and macros if applicable)
[ ] I have raised a documentation PR if applicable (Link here if required)
Release Only Checklist
[x] I have updated the version number in all relevant places
Description & motivation
This release introduces a new cross-db macro - get_array_to_string - to harmonise array to string transformations, as well as adds more features / optimisations to some of the existing macros. There are some automations and simplifications made under the hood for easier maintenance and clarity.
Features
Get string agg optimisations Add get_array_to_string macro Fix unnest macro for Postgres and snowflake (Close #105) Add delimiter parameter to get_split_to_array (Close #106) Tidy macro inheritance Add warning for no data returned for model limits Document macros in yaml, add new macro, prepare to depeciate Add action for generating docs for pages
Checklist
Release Only Checklist
dbt docs