video1.0<iframe src="https://www.loom.com/embed/14020499f5f646b6bc80c909716850fd" frameborder="0" width="2560" height="1920" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>19202560Loomhttps://www.loom.com19202560https://cdn.loom.com/sessions/thumbnails/14020499f5f646b6bc80c909716850fd-00001.gif504.93Problem: When I have lots of dbt models, I want guarantees that schemas and constraints(think: not null columns) are enforced. But that's hard to do with current dbt functionality. Short-term Solution: Custom database-specific macros to enforce column data types AND constraints AND default values. Theoretically, you may never need to run a not null test again. Long-term Solution: Follow along the work in progress here-https://github.com/dbt-labs/dbt-core/issues/6079