Skip to content

Releases: dbt-labs/dbt-utils

0.3.0

08 Apr 13:50
Compare
Choose a tag to compare

🚨 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.

🙏 Thank you to all our contributors!

dbt-utils 0.2.5

25 Feb 15:32
fcb2de5
Compare
Choose a tag to compare

Summary

This release introduces some net new functionality:

It also includes some quality of life improvements:

Thanks to all our contributors for this release!

dbt-utils 0.2.4

11 Dec 12:20
21a0b96
Compare
Choose a tag to compare

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

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!

dbt-utils 0.2.3

24 Sep 15:39
4b1c124
Compare
Choose a tag to compare

Changes:

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

Contributors:

dbt-utils 0.2.2

10 Sep 17:44
6f2aae4
Compare
Choose a tag to compare

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:

dbt-utils 0.2.1

24 Jul 15:31
c8991e6
Compare
Choose a tag to compare

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:

dbt-utils 0.2.0

15 Jul 17:20
6c545d9
Compare
Choose a tag to compare

Changes:

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

dbt-utils 0.1.25

11 Jul 19:26
Compare
Choose a tag to compare

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 🎉

dbt-utils 0.1.24

25 Jun 13:18
99e755b
Compare
Choose a tag to compare

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 🎉

dbt-utils 0.1.23

30 May 00:26
1b983ed
Compare
Choose a tag to compare

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: