DBT Testing & Data Quality Flashcards

Which built-in dbt generic test checks that all values in a column are unique?

Answer: unique

The `unique` generic test asserts that every row in a column has a distinct value.

What dbt command runs all tests defined in your project?

Answer: dbt test

`dbt test` executes all schema and data tests and reports pass/fail results.

Which YAML key is used to define generic tests on a column inside a schema.yml file?

Answer: tests

Under each column definition you add a `tests:` list to attach generic tests.

A `relationships` test in dbt verifies what condition?

Answer: Column values exist in a referenced model's column

The `relationships` test is a referential-integrity check ensuring every foreign-key value exists in the parent table.

Which dbt package is the most widely adopted for extending the set of generic tests beyond the four built-in ones?

Answer: dbt-utils

`dbt-utils` ships dozens of reusable macros and generic tests such as `expression_is_true` and `recency`.

How do you limit `dbt test` to only tests on a specific model named `orders`?

Answer: dbt test --select orders

The `--select` flag (or `-s`) accepts node selectors including model names, tags, and paths.