Querying columns with SQL

The model stg_columns (source), created with the package, lists all the columns from all the dbt nodes (models, sources, tests, snapshots)

You can use this model to help with questions such as:

• Are there columns with the same name in different nodes?
• Do any columns in the YAML configuration lack descriptions?
• Do any columns share the same name but have different descriptions?
• Are there columns with names that match a specific pattern (regex)?
• Have any prohibited names been used for columns?

Defining additional tests that match your exact requirements

You can create a custom test against {{ ref(stg_columns) }} to test for your specific check! When running the package you'd need to make sure to also include children of the package's models by using the package:dbt_project_evalutator+ selector.