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):

Da utilizzare quando si aggiungono test unitari per un modello dbt o si pratica lo sviluppo basato su test (TDD) in dbt Fonte: dbt-labs/dbt-agent-skills.