Since the dawn of time (or at least the last few years), the proserv team has been “dbt_project_evaluator”s. They've written articles, given talks, created training courses, and personally delivered just a truly obscene amount of audits. Up until now, evaluating your own dbt project—even with every aforementioned resource—would be incredibly time consuming. To quote dbt Lab’s SQL style guide, “brain time is expensive.” Enter: dbt_project_evaluator. In this talk, Grace Goheen (dbt Labs) which share how this package enables analytics engineers to follow dbt Labs own best practices by automatically curating a list of improvements, in the dbt-language of “models” and “tests” that they already know and love. By decreasing the “discovery” period, analytics engineers can use their brain time to work on actually implementing the recommended changes.

Check the slides here: https://docs.google.com/presentation/d/1U7CaoSceXumbzlPGqqAQukaz1YdOgT46sb-M6x_LNCw/edit?usp=sharing

Coalesce 2023 is coming! Register for free at https://coalesce.getdbt.com/.