DBT Testing & Data Quality Flashcards

What built-in dbt test verifies that a column contains no NULL values?

Answer: not_null

The `not_null` test fails if any row in the column contains a NULL, enforcing completeness.

Which dbt feature allows you to define custom generic tests in the `macros/` directory?

Answer: Jinja macros with test_ prefix

A macro named `test_` in the macros folder is automatically recognized by dbt as a reusable generic test.

What does `dbt test --store-failures` do at the command-line level?

Answer: Enables store_failures for all tests in the run

Passing `--store-failures` at runtime overrides individual test configs to persist failing rows for every test in that run.

Which dbt artifact file contains a summary of test results after `dbt test` runs?

Answer: run_results.json

`run_results.json` records the status (pass/fail/warn/error), timing, and row counts for every node executed.

In dbt, how do you apply a generic test to every model in a subdirectory using a schema.yml default config?

Answer: Add the test under a models: key in dbt_project.yml

The `models:` key in dbt_project.yml supports test configs that cascade to all models within a specified path.

Which accepted_values test parameter makes the test case-insensitive?

Answer: case_sensitive: false

Setting `case_sensitive: false` in the `accepted_values` test config causes dbt to compare values without regard to letter case.