Is this a new bug in dbt-expectations?
Current Behavior
When row_condition is set but compare_row_condition is not set, the row_condition is also applied to the comparison model.
Expected Behavior
No condition is applied to the comparison model. Or, this behavior becomes documented in the README.
Steps To Reproduce
This test fails to run at all if another_table.marketed_date does not exist.
- dbt_expectations.expect_table_aggregation_to_equal_other_table:
arguments:
expression: SUM(total)
row_condition: marketed_date > '2025-10-16'
group_by: ["marketed_date"]
compare_model: ref("another_table")
compare_expression: COUNT(*)
compare_group_by: ["event_date"]
The workaround is to override compare_row_condition with something vacuous.
- dbt_expectations.expect_table_aggregation_to_equal_other_table:
arguments:
expression: SUM(total)
row_condition: marketed_date > '2025-10-16'
group_by: ["marketed_date"]
compare_model: ref("another_table")
compare_expression: COUNT(*)
compare_row_condition: 1 = 1
compare_group_by: ["event_date"]
Environment
- OS: macOS 15.7.1
- Python: 3.12.8
- dbt: 1.10.13
- dbt-expectations: 0.10.9
Which database adapter are you using with dbt?
Additional Context
Possibly related to #13 but that issue lacks details.
Is this a new bug in dbt-expectations?
Current Behavior
When
row_conditionis set butcompare_row_conditionis not set, therow_conditionis also applied to the comparison model.Expected Behavior
No condition is applied to the comparison model. Or, this behavior becomes documented in the README.
Steps To Reproduce
This test fails to run at all if
another_table.marketed_datedoes not exist.The workaround is to override
compare_row_conditionwith something vacuous.Environment
Which database adapter are you using with dbt?
Additional Context
Possibly related to #13 but that issue lacks details.