dbt-labs/dbt-utils 0.6.5

dbt-utils 0.6.5

on GitHub

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