Awesome

dbt-yaml-check

dbt-yaml-check checks that columns defined in YAML also exist in SQL.

This is particularly useful for identifying extraneous columns and typos in column names.

Installation

dbt-yaml-check requires Python version 3.7 or higher.

pip install dbt-yaml-check

Usage

$ cd jaffle_shop
$ dbt run
$ dbt docs generate
$ dbt-yaml-check
+-----------+--------------------+-----+------+
|   Model   |       Column       | SQL | YAML |
+-----------+--------------------+-----+------+
| customers | total_order_amount |  ✕  |  ✓   |
+-----------+--------------------+-----+------+

FAQ

How can I specify a custom target directory?

Use the target-dir option like so: dbt-yaml-check --target-dir <path_to_your_target>.