I gave a positive review of dbt's testing capabilities in this other comment: https://news.ycombinator.com/item?id=36720013 https://news.ycombinator.com/item?id

I gave a positive review of dbt's testing capabilities in this other comment: https://news.ycombinator.com/item?id=36720013 https://news.ycombinator.com/item?id=36720013 This is what the actual generic tests look like. There's also support for one-off SQL-based tests: https://docs.getdbt.com/reference/resource-properties/tests#out-of-the-box-tests https://docs.getdbt.com/reference/resource-properties/tests#... This article covers a lot of ground as to how to actually use dbt tests in practice. I'm particularly glad they mentioned the dbt-utils and dbt-expectations libraries: https://www.datafold.com/blog/7-dbt-testing-best-practices https://www.datafold.com/blog/7-dbt-testing-best-practices The dbt ecosystem is also a strength. This article has good examples of the type of tooling and libraries in the ecosystem: https://meltano.com/blog/top-5-of-dbt-packages-and-tools-in-2022/ https://meltano.com/blog/top-5-of-dbt-packages-and-tools-in-... I have no affiliation with any of the above linked companies, just a happy dbt user! I'll also add that I don't use the dbt cloud, just invoke the dbt cli in a backend task runner.