0.3.0

🚨 This release contains a breaking change

This package now requires dbt >=0.15.1

Fixes

• The surrogate_key macro now takes a list instead multiple arguments (#197 @DylanBaker).

-- before
{{ dbt_utils.surrogate_key('field_a', 'field_b') }}
-- after
{{ dbt_utils.surrogate_key(['field_a', 'field_b']) }}

Support for multiple arguments will be removed in a future release.

• Documentation improvements (#201 @CaptainEli , #203 @avishalom)
• Whitespace cleanups (#196 / #199 @Limess)

🙏 Thank you to all our contributors!

dbt-utils 0.2.5

Summary

This release introduces some net new functionality:

• Add a datediff implementation for postgres (#187 @mjumbewu)
• Safe add macro (#191 @invinceyble)

It also includes some quality of life improvements:

• Whitespace cleanup 🙏(#193 @invinceyble, #188 @Limess)
• Documentation improvements (#186 @nickwu241, #184 @emilieschario)

Thanks to all our contributors for this release!

dbt-utils 0.2.4

Summary

This release introduces some net new functionality:

• Test for mutually exclusive ranges (#166)
• Test for unique combination of columns (#177)
• get_query_results_as_dict macro (originally referred to as fetch macro) (#160 @ChrisLawliss)
• Width bucket macro (#179 @clausherther)

It also includes some quality of life improvements

• Documentation improvements (#164 @louisguitton, #170)
• Whitespace clean ups 🙏 (#174 @ltchikindas, #176 @mjumbewu)
• Use getdate instead of current_timestamp on Redshift (#171 @tjengel)
• Replace references to tables with relations (#178)

Heads up!

This release replaces the get_tables_by_prefix and union_tables macros. These macros will be deprecated in a future release of this package. We recommend you use the get_relations_by_prefix and union_relations macros instead.

🎉 Contributors: 🎉

Thanks to our community members who contributed to this release!

• @clausherther
• @louisguitton
• @ltchikindas
• @mjumbewu
• @tjengel

dbt-utils 0.2.3

Changes:

• Add relationships_where schema test to assert foreign key constraints on a filter (#161)

Contributors:

• @MartinGuindon (#161) (macro courtesy of @tconbeer)

dbt-utils 0.2.2

Changes:

• Update documentation for get_column_values macro
• Update documentation for get_tables_by_prefix macro
• Update documentation for unpivot macro
• Fix for misused database parameter in get_tables_by_prefix_sql macro (#157, #158) (@clausherther)

Contributors:

• @clausherther (#158)

dbt-utils 0.2.1

Changes:

• Fix for compilation error in get_column_values if a ref is provided for a model which does not exist in the database (#152) (@emilieschario)
• Fix for error in test suite (#151)

Contributors:

• @emilieschario (#152)

dbt-utils 0.2.0

Changes:

• Supports (and requires) dbt >= 0.14.0 (#149)

dbt-utils 0.1.25

Changes:

• Add logger macros (#131)
• Add condition parameter to expression_is_true schema test (#147)
• Make schema in get_tables_by_prefix case insensitive (#148)

🎉 Contributors 🎉

• @dcereijodo (#147)

dbt-utils 0.1.24

Changes:

• Add intersect macro (#140)
• Fix the integration test suite (#141)
• Add remove, field_name, and value_name parameters to the unpivot macro (#142)
• Added int, float, and bigint cross-db macros (#143)
• Update readme with better installation instructions (#144)

🎉 Contributors 🎉

• @remigabillet (#142)
• @siephen (#143)

dbt-utils 0.1.23

This release includes the following changes:

Features:

• 0.13.x compatibility (removes warnings by avoiding deprecated context methods) (#133)
• Add quote_identifiers argument to the pviot macro (#135)
• Improved readme (#124)

Fixes:

• Fix for insert_by_period materialization on dbt v0.13.x (#128)

Contributors:

• @carlyfk: (#135)
• @clausherther (#128)
• @MartinGuindon (#124)
• @jtcohen6 (#133)