dbt-utils v0.8.3
New features
- A macro for deduplicating data,
deduplicate()
(#335, #512) - A cross-database implementation of
listagg()
(#530) - A new macro to get the columns in a relation as a list,
get_filtered_columns_in_relation()
. This is similar to thestar()
macro, but creates a Jinja list instead of a comma-separated string. (#516)
Fixes
get_column_values()
once more raises an error when the model doesn't exist and there is no default provided (#531, #533)get_column_values()
raises an error when used with an ephemeral model, instead of getting stuck in a compilation loop (#358, #518)- BigQuery materialized views work correctly with
get_relations_by_pattern()
(#525)
Quality of life
- Updated references to 'schema test' in project file structure and documentation (#485, #521)
date_trunc()
anddatediff()
default macros now have whitespace control to assist with linting and readability #529star()
no longer raises an error during SQLFluff linting (#506, #532)
Contributors:
- @judahrand (#512)
- @b-moynihan (#521)
- @sunriselong (#529)
- @jpmmcneill (#533)
- @KamranAMalik (#532)
- @graciegoheen (#530)
- @luisleon90 (#525)
- @epapineau (#518)
- @patkearns10 (#516)