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

在為 dbt 模型添加單元測試或在 dbt 中練習測試驅動開發 (TDD) 時使用 來源：dbt-labs/dbt-agent-skills。

查看原文