Skip to content

Releases: calogica/dbt-expectations

dbt-expectations v0.4.1

24 Jul 13:53
e47358d
Compare
Choose a tag to compare

dbt-expectations v0.4.1

Fixes

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

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

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

dbt-expectations v0.4.0

13 Jul 18:40
75bb335
Compare
Choose a tag to compare

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

11 Jul 12:20
03da5cd
Compare
Choose a tag to compare

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

30 Jun 18:55
909c10b
Compare
Choose a tag to compare

dbt-expectations v0.3.6

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

dbt-expectations v0.3.5

29 Jun 13:50
0fe9468
Compare
Choose a tag to compare

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

dbt-expectations 0.3.4

06 Jun 23:31
730d195
Compare
Choose a tag to compare

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!)

dbt-expectations 0.3.3

04 May 15:16
4d3b947
Compare
Choose a tag to compare

Removes dependency on spark-utils.

Users running this package on non-core (Snowflake, BigQuery, Redshift, Postgres) platforms, will need to use a package like spark_utils to shim macros.

For example, in packages.yml, you will need to include the relevant package:

  - package: fishtown-analytics/spark_utils
    version: <latest or range>

And reference in the dispatch list for dbt_utils in dbt_project.yml:

vars:
    dbt_utils_dispatch_list: [spark_utils]

dbt-expectations 0.3.2

22 Apr 19:45
f100088
Compare
Choose a tag to compare

Adds:

  • expect_column_distinct_count_to_equal_other_table (#48 #50 )
  • expect_grouped_row_values_to_have_recent_data (#47 #49 )

dbt-expectations 0.3.1

19 Apr 15:19
f353255
Compare
Choose a tag to compare
  • #45 Adds ability to set row_condition on table row count tests
  • #44 Adds better support for tolerance_percent for equal_expression macro

dbt-expectations 0.3.0

10 Apr 14:28
1a9f0fb
Compare
Choose a tag to compare
  • Adds better support for PostgreSQL (#40)
  • Adds new test: expect_table_column_count_to_equal_other_table_times_factor (#37 contributed by @nysthee)