elementary
elementary copied to clipboard
Add 'where expression' support to table and column anomalies tests
On the new 'dimension anomalies' test we implemented support of getting 'where expression' param, which contains an SQL expression for filtering the tested data. The same logic can be implemented for the other tests as well.
Why not use dbt native 'where' as requested on this issue? dbt returns an SQL expression when you use it, and we expect a relation (issue in dbt).