This linter can really enforce some best practices https://github.com/sqlfluff/sqlfluff https://github.com/sqlfluff/sqlfluff A list of best practices: https://

This linter can really enforce some best practices https://github.com/sqlfluff/sqlfluff https://github.com/sqlfluff/sqlfluff A list of best practices: https://docs.getdbt.com/guides/legacy/best-practices https://docs.getdbt.com/guides/legacy/best-practices And shameless plug but there's a chapter on modeling in my book: https://theinformedcompany.com https://theinformedcompany.com