- Adds optional
step
param to expect_column_values_to_be_{in,de}creasing by @vitorbaptista in #316
- Upgrade for dbt 1.8.x by @clausherther in #309
- [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
- Update Test Expecting Select Column Values To Be Unique Within Record by @bkimjin in #300
- Fix sum_total in expect_multicolumn_sum_to_equal to accept column names by @VDFaller in #291
- Added experimental spark support by @clausherther in #279
- Changed upper range of dbt-date version dependency by @clausherther in #286
- Add count to expect_compound_columns_to_be_unique by @VDFaller in #261
- Add duckdb support by @clausherther in #271
- Update README.md by @mbkupfer in #268
- Add support for regex flags for BigQuery by @lookslikeitsnot in #253
- 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
- added negative tests for regex email test to make sure those tests are failing when they should
- Add optional flags argument to regex tests by @tconbeer in #247
- Update docs site by @clausherther in #235
- Add explicit reference to dbt.length() by @clausherther in #234
- Disabling SQLFluff by @clausherther in #242
- Fix dangling datediff reference by @clausherther in #233
- Make type macro calls fully qualified by @clausherther in #232
- Clean up quote values defaults by @clausherther in #231
- Fix indentation of examples by @clausherther in #219
- Update README by @clausherther in #220
- Update logo paths by @clausherther in #221
- 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
NOTE: including this package in your project will no longer auto-include dbt-utils
!
- Remove references to dbt_utils by @clausherther in #217
- Fix boolean logic in
expect_compound_columns_to_be_unique
ignore_row_if
by @clausherther in #202- Fixed issue https://github.com/calogica/dbt-expectations/issues/200 raised by @mcannamela
- Refactor ignore_row_if logic by @clausherther in #204
- Add SQL Fluff support by @clausherther in #198
- 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
- Add option to escape raw strings in RegEx functions by @clausherther in #191
- @dylanrigal made their first contribution in #193
- Requires dbt 1.2.x (via #189)
- Migrate to dbt-utils 0.9.0 and dbt-date 0.6.0 by @clausherther in #189
- Fixed timestamp comparisons in expect_grouped_row_values_to_have_recent_data by @clausherther in #179
- Add example for dynamic date params in expect_row_values_to_have_data_for_every_n_datepart by @clausherther in #174
- Fix take_diff syntax in moving stddev test by @karanhegde in #178
Patch Release
- Fix
expect_compound_columns_to_be_unique
to properly handleignore_row_if
by @clausherther in #171
- 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
toexpect_row_values_to_have_data_for_every_n_datepart
by @gofford in #141
- Set flakey integration tests to
warn
in #162
- Adds test for column presence by @rcaddell in #149
- Fix emails.sql by @clausherther in #153
- Fix expect_row_values_to_have_recent_data issues on bigquery by @clausherther in #147
- @rcaddell made their first contribution in #149
- Add
group_by
parameter toexpect_column_values_to_be_increasing
andexpect_column_values_to_be_decreasing
(#146 @Lucasthenoob)
- Fix
expect_row_values_to_have_recent_data
to use current timestamp by @MrJoosh in #145 (also fixes https://github.com/calogica/dbt-expectations/issues/104)
- Add new
expect_column_values_to_have_consistent_casing
test by @agusfigueroa-htg in #138
- Update README.md by @kdw2126 in #134
- Fix documentation to note DBT 1.0.0 compatibility by @kdw2126 in #136
- @kdw2126 made their first contribution in #134
- @agusfigueroa-htg made their first contribution in #138
- @MrJoosh made their first contribution in #145
- Add better support for Redshift by typing implicit
varchar
fields explicitly to strings. (#131 #132)
- adds full support for dbt 1.x without backwards compatability
- supports
dbt-date 0.5.0
, which supportsdbt-utils 0.8.0
- Patch: adds support for dbt 1.x
- 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
- @makotonium made their first contribution in #124
- @samantha-guerriero-cko made their first contribution in #126
- Fix missing group by default value in string_matching macros (#126 by @samantha-guerriero-cko)
- Append missing optional parameters documentation to README.md (#124 by @makotonium)
- Add an optional argument to allow for intervals of
date_part
inexpect_row_values_to_have_data_for_every_n_datepart
. (#110 by @lewisarmistead)
- Fixed a regression introduced in 0.4.3 that made
expect_table_columns_to_match_ordered_list
incomatible with Redshift (#123 by @mirosval)
- 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)
- Fixes incompatibility on Snowflake with use of
row_number()
withoutorder by
inexpect_table_columns_to_match_ordered_list
(#112)
- Supports dbt 0.21.x
- Added
row_condition
toexpect_grouped_row_values_to_have_recent_data
andexpect_row_values_to_have_recent_data
to allow for partition filtering before applying the recency test (#106 w/ @edbizarro)
- Converted Jinja set logic to SQL joins to make it easier to follow and iterate in the future (#108)
-
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)
-
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)
- Fix join in
expect_column_values_to_be_in_set
(#91 @ahmedrad) - Add support for Redshift
random
function inrand
macro (#92 @ahmedrad)
- Remove unnecessary macro to fix issue with 0.19.2 (#88)
-
Added a new macro,
expect_row_values_to_have_data_for_every_n_datepart
, which tests whether a model has values for every groupeddate_part
.For example, this tests whether a model has data for every
day
(grouped ondate_col
) from either a specifiedstart_date
andend_date
, or for themin
/max
value of the specifieddate_col
.tests: - dbt_expectations.expect_row_values_to_have_data_for_every_n_datepart: date_col: date_day date_part: day
-
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)
-
Added support for optional
min_value
andmax_value
parameters to all*_between_*
tests. (#70) -
Added support for
strictly
parameter tobetween
tests. If set toTrue
,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
- Corrected a typo in the README (#67)