{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/14020499f5f646b6bc80c909716850fd\" frameborder=\"0\" width=\"2560\" height=\"1920\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1920,"width":2560,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1920,"thumbnail_width":2560,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/14020499f5f646b6bc80c909716850fd-00001.gif","duration":504.93,"title":"Column Type Constraints as dbt Native: Demo","description":"Problem: 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.\n\nShort-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.\n\nLong-term Solution: Follow along the work in progress here-https://github.com/dbt-labs/dbt-core/issues/6079"}