CHANGELOG.md

dbt-expectations v0.10.4

New Features

• Adds optional step param to expect_column_values_to_be_{in,de}creasing by @vitorbaptista in #316

Docs

• Update README.md by @thomaslaber in #303
• "Expect" instead of "Except" by @dbeatty10 in #308

Fixes

• Upgrade for dbt 1.8.x by @clausherther in #309

dbt-expectations v0.10.3

New Features

• [CI] Uprade to dbt=1.7.x by @clausherther in #292
• Add Trino Support by @damian3031 in #294
• Add Trino md5 macro by @clausherther in #301

dbt-expectations v0.10.2

Fixes

• Update Test Expecting Select Column Values To Be Unique Within Record by @bkimjin in #300

dbt-expectations v0.10.1

Fixes

• Fix sum_total in expect_multicolumn_sum_to_equal to accept column names by @VDFaller in #291

dbt-expectations v0.10.0

New Features

• Added experimental spark support by @clausherther in #279
• Changed upper range of dbt-date version dependency by @clausherther in #286

dbt-expectations v0.9.0

New Features

• Add count to expect_compound_columns_to_be_unique by @VDFaller in #261
• Add duckdb support by @clausherther in #271

Docs

• Update README.md by @mbkupfer in #268

dbt-expectations v0.8.5

New Features

• Add support for regex flags for BigQuery by @lookslikeitsnot in #253

dbt-expectations v0.8.4

Fixes

• escape quotes in expect_column_values_to_be_in_type_list by @RobbertDM in #251
• Fix postgres__regexp_instr not validating regex #249 by @lookslikeitsnot in #250

Under The Hood

• added negative tests for regex email test to make sure those tests are failing when they should

dbt-expectations v0.8.3

New Features

• Add optional flags argument to regex tests by @tconbeer in #247

Docs

• Update docs site by @clausherther in #235

Under The Hood

• Add explicit reference to dbt.length() by @clausherther in #234
• Disabling SQLFluff by @clausherther in #242

dbt-expectations v0.8.2

Fixes

• Fix dangling datediff reference by @clausherther in #233

dbt-expectations v0.8.1

Fixes

• Make type macro calls fully qualified by @clausherther in #232
• Clean up quote values defaults by @clausherther in #231

Documentation

• Fix indentation of examples by @clausherther in #219
• Update README by @clausherther in #220
• Update logo paths by @clausherther in #221

Additions

• Add expect_table_aggregation_to_equal_other_table by @clausherther in #224
• Adds group by to expect_table_row_count_to_equal_other_table by @clausherther in #225

dbt-expectations v0.8.0

Breaking Changes

NOTE: including this package in your project will no longer auto-include dbt-utils!

• Remove references to dbt_utils by @clausherther in #217

dbt-expectations v0.7.0

Breaking Changes

• Fix boolean logic in expect_compound_columns_to_be_unique ignore_row_if by @clausherther in #202
  • Fixed issue #200 raised by @mcannamela
• Refactor ignore_row_if logic by @clausherther in #204

Under The Hood

• Add SQL Fluff support by @clausherther in #198

dbt-expectations v0.6.1

New Features

• Add expect_column_distinct_count_to_be_less_than.sql by @dylanrigal in #193
• Add group_by option to expect_column_values_to_be_within_n_moving_stdevs by @clausherther in #182

Fixes

• Add option to escape raw strings in RegEx functions by @clausherther in #191

New Contributors

• @dylanrigal made their first contribution in #193

dbt-expectations v0.6.0

Breaking Changes

• Requires dbt 1.2.x (via #189)
• Migrate to dbt-utils 0.9.0 and dbt-date 0.6.0 by @clausherther in #189

dbt-expectations v0.5.8

Fixes

• Fixed timestamp comparisons in expect_grouped_row_values_to_have_recent_data by @clausherther in #179

dbt-expectations v0.5.7

Documentation

• Add example for dynamic date params in expect_row_values_to_have_data_for_every_n_datepart by @clausherther in #174

Fixes

• Fix take_diff syntax in moving stddev test by @karanhegde in #178

dbt-expectations v0.5.6

Patch Release

Fixes

• Fix expect_compound_columns_to_be_unique to properly handle ignore_row_if by @clausherther in #171

dbt-expectations v0.5.5

New Features

• Add automated integration testing with CircleCI in #161
• Show group_by columns in validation errors for column increasing test by @dluftspring in #158
• Add exclusion_condition to expect_row_values_to_have_data_for_every_n_datepart by @gofford in #141

Fixes

• Set flakey integration tests to warn in #162

dbt-expectations v0.5.4

New Features

• Adds test for column presence by @rcaddell in #149

Fixes

• Fix emails.sql by @clausherther in #153
• Fix expect_row_values_to_have_recent_data issues on bigquery by @clausherther in #147

New Contributors

• @rcaddell made their first contribution in #149

dbt-expectations v0.5.3

New Features

• Add group_by parameter to expect_column_values_to_be_increasing and expect_column_values_to_be_decreasing (#146 @Lucasthenoob)

dbt-expectations v0.5.2

Fixes

• Fix expect_row_values_to_have_recent_data to use current timestamp by @MrJoosh in #145 (also fixes #104)

New Features

• Add new expect_column_values_to_have_consistent_casing test by @agusfigueroa-htg in #138

Doc Updates 💌

• Update README.md by @kdw2126 in #134
• Fix documentation to note DBT 1.0.0 compatibility by @kdw2126 in #136

New Contributors

• @kdw2126 made their first contribution in #134
• @agusfigueroa-htg made their first contribution in #138
• @MrJoosh made their first contribution in #145

dbt-expectations v0.5.1

Fixes

• Add better support for Redshift by typing implicit varchar fields explicitly to strings. (#131 #132)

dbt-expectations v0.5.0

• adds full support for dbt 1.x without backwards compatability
• supports dbt-date 0.5.0, which supports dbt-utils 0.8.0

dbt-expectations v0.4.7

• Patch: adds support for dbt 1.x

dbt-expectations v0.4.6

What's Changed

• Append missing optional parameters documentation to README.md by @makotonium in #124
• Fix missing group_by default value in string_matching macros by @samantha-guerriero-cko in #126

New Contributors

• @makotonium made their first contribution in #124
• @samantha-guerriero-cko made their first contribution in #126

dbt-expectations v0.4.5

Fixes

• Fix missing group by default value in string_matching macros (#126 by @samantha-guerriero-cko)

Doc Updates

• Append missing optional parameters documentation to README.md (#124 by @makotonium)

dbt-expectations v0.4.5

Features

• Add an optional argument to allow for intervals of date_part in expect_row_values_to_have_data_for_every_n_datepart. (#110 by @lewisarmistead)

Fixes

• Fixed a regression introduced in 0.4.3 that made expect_table_columns_to_match_ordered_list incomatible with Redshift (#123 by @mirosval)

dbt-expectations v0.4.4

Fixes

• Replaced hardcoded value in expect_column_to_exist with mapping call to provided transform filter and join to reduce list back to single value. (#118 @UselessAlias)

dbt-expectations v0.4.3

Fixes

• Fixes incompatibility on Snowflake with use of row_number() without order by in expect_table_columns_to_match_ordered_list(#112)

Features

Under the hood

• Supports dbt 0.21.x

dbt-expectations v0.4.2

Features

• Added row_condition to expect_grouped_row_values_to_have_recent_data and expect_row_values_to_have_recent_data to allow for partition filtering before applying the recency test (#106 w/ @edbizarro)

Under the hood

• Converted Jinja set logic to SQL joins to make it easier to follow and iterate in the future (#108)

dbt-expectations v0.4.1

Fixes

• expect_table_columns_to_match_list remove '' to leave columns as numbers (#98)

• expect_table_columns_to_match_ordered_list now explicitly casts the column list to a string type (#99)

• Fixes regex matching tests for Redshift by adding a Redshift specific adapter macro in regexp_instr (#99 @mirosval)

dbt-expectations v0.4.0

Breaking Changes

• Requires dbt >= 0.20

• Requires dbt-date >= 0.4.0

• Updates test macros to tests to support dbt >= 0.20

• Updates calls to adapter.dispatch to support dbt >= 0.20 (see Changes to dispatch in dbt v0.20 #78)

dbt-expectations v0.3.7

• Fix join in expect_column_values_to_be_in_set (#91 @ahmedrad)
• Add support for Redshift random function in rand macro (#92 @ahmedrad)

dbt-expectations v0.3.6

• Remove unnecessary macro to fix issue with 0.19.2 (#88)

dbt-expectations v0.3.5

Features

• Added a new macro, expect_row_values_to_have_data_for_every_n_datepart, which tests whether a model has values for every grouped date_part.

  For example, this tests whether a model has data for every day (grouped on date_col) from either a specified start_date and end_date, or for the min/max value of the specified date_col.

  tests:
      - dbt_expectations.expect_row_values_to_have_data_for_every_n_datepart:
          date_col: date_day
          date_part: day

Fixes

• Updated description of type check tests (#84 @noel)

• Fixed join syntax because Twitter induced guilt: https://twitter.com/emilyhawkins__/status/1400967270537564160

• Bump version of dbt-date to < 0.4.0 (#85)

dbt-expectations v0.3.4

Features

• Added support for optional min_value and max_value parameters to all*_between_* tests. (#70)

• Added support for strictly parameter to between tests. If set to True, striclty changes the operators >= and <= to> and <.

  For example, while

  dbt_expectations.expect_column_stdev_to_be_between:
      min_value: 0

  evaluates to >= 0,

  dbt_expectations.expect_column_stdev_to_be_between:
      min_value: 0
      strictly: True

  evaluates to > 0. (#72, #74)

Fixes

• Corrected a typo in the README (#67)

Under the hood

• Refactored get_select function to generate SQL grouping more explicitly (#63))

• Added dispatch call to expect_table_row_count_to_equal to make it easier to shim macros for the tsql-utils package (#64 Thanks @alieus!)