calogica/dbt-expectations 0.7.0

dbt-expectations 0.7.0

on GitHub

Fixes (Breaking Changes)

• Fix boolean logic in expect_compound_columns_to_be_unique ignore_row_if by @clausherther in #202

  • The behavior of ignore_row_if is now reversed, i.e. if you were previously using ignore_row_if: "any_value_is_missing" (overwriting the default all_values_are_missing), you should check your tests to make sure you're getting the correct results in the updated version.
  • all_values_are_missing means that rows are excluded where all of the test columns are null
  • any_value_is_missing means that rows are excluded where either of the test columns are null

• Refactor ignore_row_if logic by @clausherther in #204

  • also updated expect_select_column_values_to_be_unique_within_record with the fix above

• Fix group by logic in grouped recency and stdev tests by @clausherther in #205

  • group_by is now correctly respected in both the initial aggregation and subsequent tests

Fixes

• Remove dangling dbt-utils reference by @clausherther in #208

Testing/Documentation

• Add SQL Fluff support by @clausherther in #198

Full Changelog: 0.6.1...0.7.0