I am looking for some advice in how to test where clauses that are based on current_date. Much of the project that I am working on has views that are based on effective date controls. I want to be able to write Equality tests that test that the boundarys are performing correctly as we have cases where the dev have got the < mixed up with <=. Resulting in a boundary error
hi there, you might find a useful schema test on dbt package: