Most SQL-based teams should not consider themselves as engineers...
I recently encountered a team with over 350 DBT models, 0 unit tests (although DBT has a dedicated package for this purpose), 0 documentation, and 0 diagrams built to visualize relationships between models (the only reference available to understand their models was the models themselves)... Additionally, more than half of the DBT models contained over 350 lines of code, with nested queries upon nested queries and CTEs stacked on top of each other.
Most SQL-based teams should not consider themselves as engineers...
I recently encountered a team with over 350 DBT models, 0 unit tests (although DBT has a dedicated package for this purpose), 0 documentation, and 0 diagrams built to visualize relationships between models (the only reference available to understand their models was the models themselves)... Additionally, more than half of the DBT models contained over 350 lines of code, with nested queries upon nested queries and CTEs stacked on top of each other.
I rejected that project...