dbt-utils 0.6.5

Rejoice, ye dbt-utils users, for we have chosen to move all non-breaking changes into a patch release! Yes yes, we know this isn't strictly the way of semver, but we wanted to get as many of these features out to you before releasing 0.7.0, which is going to contain quite a few breaking changes.

So, what's in this release? Glad you asked...

Features

• Add new accepted_range test (#276 @joellabes)
• Make expression_is_true work as a column test (code originally in #226 from @elliottohara, merged via #313)
• Add new schema test, not_accepted_values (#284 @JavierMonton)
• Support a new argument, zero_length_range_allowed in the mutually_exclusive_ranges test (#307 @zemekeneng)
• Add new schema test, sequential_values (#318, inspired by @hundredwatt)
• Support quarter in the postgres__last_day macro (#333 @seunghanhong)
• Add new argument, unit, to haversine_distance (#340 @bastienboutonnet)
• Add new schema test, fewer_rows_than (code originally in #221 from @dmarts, merged via #343)

Fixes

• Handle booleans gracefully in the unpivot macro (#305 @avishalom)
• Fix a bug in get_relation_by_prefix that happens with Snowflake external tables. Now the macro will retrieve tables that match the prefix which are external tables (#351 @upjohnc)
• Fix cardinality_equality test when the two tables' column names differed (#334 @joellabes)

Under the hood

• Fix Markdown formatting for hub rendering (#336 @coapacetic)
• Reorder readme and improve docs

dbt-utils 0.6.4

dbt-utils v0.6.4

This is a patch release with no breaking changes.

Instead we made lots of teeny, tiny, under-the-hood improvements, mostly to help out adapter maintainers and ourselves as utils maintainers :)

Fixes

• Fix insert_by_period to support dbt v0.19.0, with backwards compatibility for earlier versions (#319, #320)

Under the hood

• Speed up CI via threads, workflows (#315, #316)
• Fix equality test when used with ephemeral models + explicit column set (#321)
• Fix get_query_results_as_dict integration test with consistent ordering (#322)
• All macros are now properly dispatched, making it possible for non-core adapters to implement a shim package for dbt-utils (#312) Thanks @chaerinlee1 and @swanderz
• Small, non-breaking changes to accommodate TSQL (can't group by column number references, no real TRUE/FALSE values, aggregation CTEs need named columns) (#310) Thanks @swanderz
• Make get_relations_by_pattern and get_relations_by_prefix more powerful by returning relation.type (#323)

dbt-utils 0.6.3

This is a patch release with no substantive changes.

Quality of life

• Bump require-dbt-version: [">=0.18.0", "<0.20.0"]. This package will support dbt v0.19.0 without any breaking changes.
• Documentation updates (readme + issue/PR templates)

dbt-utils 0.6.2

Another day, another bugfix release. Happens to the best of us!

This release fixes a regression that was introduced in 0.6.0.

Fixes

• Fix the logic in get_tables_by_pattern_sql to ensure non-default arguments are respected (#279)

dbt-utils v0.6.1

This is a bugfix release

Fixes

• Handle schema pattern on BigQuery (#275)

dbt-utils v0.6.0

dbt-utils v0.6.0

Thanks to our contributors @tayloramurphy and @JoshuaHuntley

Breaking changes

• 🚨 dbt v0.18.0 or greater is required for this release. If you are not ready to upgrade, consider using a previous release of this package
• 🚨 The get_tables_by_prefix, union_tables and get_tables_by_pattern macros have been removed

Migration instructions

Migration instructions can be found in the Changelog

Features

• Switch usage of adapter_macro to adapter.dispatch, and define dbt_utils_dispatch_list,
  enabling users of community-supported database plugins to add or override macro implementations
  specific to their database (#267)
• Use add_ephemeral_prefix instead of hard-coding a string literal, to support
  database adapters that use different prefixes (#267)
• Implement a quote_columns argument in the unique_combination_of_columns schema test (#270 @JoshuaHuntley)

Quality of life

• Remove deprecated macros get_tables_by_prefix and union_tables (#268)
• Remove get_tables_by_pattern macro, which is equivalent to the get_tables_by_pattern_sql macro (the latter has a more logical name) (#268)

dbt-utils 0.5.1

This is a bug fix release

Quality of life

• Improve release process, and fix tests (#251)
• Make deprecation warnings more useful (#258 @tayloramurphy 🙌 )

dbt-utils 0.5.0

New functionality has been included in this release!

Features

• Throw a nice error when trying to use a macro that requires the information schema on an ephemeral model (#243) (🚨 may cause previously silent errors to no longer be silent)
• Add unique_where and not_null_where relationship tests (#250 @MartinGuindon)
• Add distinct argument to the pivot macro (#248 @DylanBaker)
• Add get_relations_by_pattern macro (#220 @JDW818)

Fixes

• Fix incorrect test behavior for the unpivot macro (#249 @avishalom)

Quality of life

• Replace BigQuery __TABLES_SUMMARY__ with INFORMATION_SCHEMA (#247 @preston-hf)

dbt-utils v0.4.1

This is a bug-fix release

Fixes

• Ensure surrogate key handles single arg (#242, fixes #241)

0.4.0

🚨 This release contains a breaking change

This package now requires dbt >=0.17.0

Features

• v0.17.0 compatibility (#235 @DylanBaker) (🚨 breaking change)

Fixes

• Return a relation in the insert-by-period materialization (#236 @jtalmi)

Under the hood

• Use python v3.6.3 for integration tests (#233)
• Add GitHub templates (#217 #222)
• Update star macro to use adapter.quote (#205 @bjgbeelen)
• Simplify running the integration tests (#211 @bjgbeelen)
• Update test scripts to ensure existing profiles are not removed (#231)

🙏 Thank you to all our contributors!