dbt-unit-testing

What problem does it solve?

dbt-unit-testing helps analytics engineers validate dbt transformations by writing unit tests that run without a warehouse connection, catching logic errors early with mocked inputs and expected outputs.

Core Features & Use Cases

• Create unit tests in the model schema.yml using the unit_tests section to simulate inputs and verify outputs.
• Use given blocks with mocked ref() and source() inputs, and optionally inline fixtures or CSV fixtures for larger datasets.
• Support edge-case coverage, overrides for deterministic behavior, and macro compatibility to test compiled SQL rather than internals.

Quick Start

Provide a unit test by adding a unit_tests entry under the model's schema.yml, supply mocked inputs in given blocks, and assert expected outputs in the expect section.