Problem
I need to define contracts and test for my models outside of a “standard” yml or sql
Background
We generate dbt yml and sql files using mapping dedfinitions from outside dbt. We include some automatically generated tests, like uniquness verificaitons of primary keys, foreign keys, checks of service columns population, but we also need to set contracts on our models. Those contracts expected to be mostly additional constraints, like expected values ranges, not null etc, but not only - csan be quite compex queries. It is time-consuming to add siupport all this to autogeneration. I am looking for some more lightweight solution, like addition of a new yml, or link to testsuite that covers requirements, maybe utility that can extend existing definitions. We are currently using dbt Core.