adding-dbt-unit-test

SKILL.md

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

À utiliser lors de l'ajout de tests unitaires pour un modèle dbt ou lors de la pratique du développement piloté par les tests (TDD) dans dbt Source : dbt-labs/dbt-agent-skills.

Voir l'original