Hologram's SQL Style Guide

SQL at Hologram

• is explicit (fully qualified table names & joins), literate (readable), and lowercase (SELECT)
• uses CTEs following the single responsibility principle ("do one thing")

Comprehensive guidelines are laid out in the following three documents:

• Mazur's SQL Style Guide - general SQL
• dbt Style Guide - DBT-specific
• The sqlfmt style - used to automatically lint & reformat SQL where possible