dbt Analytics Engineering Certification

Singular tests and SQL models are defined in .sql files. Generic tests are applied to resources through .yml properties, while their reusable test logic may itself be defined in SQL. Column descriptions are also typically declared in .yml properties. Warehouse column types come from data-platform metadata, and dbt builds model dependencies from references such as ref() in model SQL. (docs.getdbt.com)