rittmananalytics / droughty

Droughty helps keep your workflow dry
https://droughty.readthedocs.io/en/latest/
MIT License
62 stars 6 forks source link

dbt_utils_expression_is_true test assertion #52

Open jack-env opened 1 year ago

jack-env commented 1 year ago

Bug description

droughty asserts dbt_utils_expression_is_true test on columns application_valid_from_dt and application_valid_to_dt:

- 'dbt_utils.expression_is_true:expression: valid_from < valid_to'

Expected behaviour

In this use case, I would expect only the not_null test to have been assigned by droughty to these date columns (flagged by 'dt' syntax in column name).

Screenshots/Video

Screenshot 2023-01-20 at 11 04 01

Workaround

Using test_overwrite: in droughty_schema.yaml to redefine all tests for the model in question.