adding-dbt-unit-test

In software programming, unit tests validate small portions of your functional code, and they work much the same way in dbt. dbt unit tests allow you to validate your SQL modeling logic on a small set of static inputs before you materialize your full model in production. dbt unit tests enable test-driven development, benefiting developer efficiency and code reliability.

Unit tests allow enforcing that all the unit tests for a model pass before it is materialized (i.e. dbt won't materialize the model in the database if any of its unit tests do not pass).

dbt unit test uses a trio of the model, given inputs, and expected outputs (Model-Inputs-Outputs):

Используйте при добавлении модульных тестов для модели dbt или при практике разработки через тестирование (TDD) в dbt. Источник: dbt-labs/dbt-agent-skills.