Dbt model (think unit) tests POC

[mikael]

Cross posting an light view proposal I made in another thread, hoping to get some community feedback on the approach.

Testing with fixed data set

Hi, One thing that I’ve feel missing is the ability to control different aspects of a model during different tests. Ideally I would conditionally like to change data source(s) based on which test is running to add data sources that can test both positive and negative cases; as such global settings such as env=ci doesn’t cut it (unless you want to sacrifice readability dumping all the test cases in 1 huge table and then filtering). I did a test with implementing a cte helper that returns the co…