Data tests: not_null and unique

dbt tests are assertions that run as SQL against your materialized models. The two most common generic tests are not_null (no NULLs allowed in a column) and unique (no duplicate values).

In this lesson you will declare not_null and unique tests in schema.yml under a model's columns:, then run dbt test and observe pass/fail output.