SQL style guide 2.0

Update of our SQL style guide.

• Add guidelines for case statements (@poloaraujo, @sean-rose).
• Name single-column primary keys id (@sean-rose).
• Use a single blank line around CTEs to add visual separation (@NiallRees).
• Add unit column names guideline (@NiallRees).

dbt modeling PR template 1.1

Update of our dbt modeling PR template on 2021-07-01.

• Add prompt to paste screenshot of the model lineage graph (@jaypeedevlin).

dbt coding conventions 2.0

Update of our dbt coding conventions on 2021-08-06.

• Specify dbt project structure (@NiallRees).
• Add marts directory (@NiallRees).
• Rename "staging" models "intermediate" models with an int_ prefix (@NiallRees).
• Add source_ prefix to source models (@NiallRees).
• Separate models' output columns into logical groups (@sean-rose).
• Don't use fact_, dim_, or agg_ prefixes for model names (@sean-rose).
• Cast timestamps to the client's timezone (@jaypeedevlin).
• Require alphabetical order in YAML files (@jaypeedevlin).
• Document source models and sources (@jaypeedevlin).

Looker style guide 1.0

Initial release of our Looker style guide on 2021-06-17 by @joshuaneman.

Looker modeling PR template 1.0

Initial release of our Looker modeling PR template on 2020-11-24 by @joshuaneman.

SQL style guide 1.1

Update of our SQL style guide on 2020-11-03.

• Added a section about where to put filters during an inner join (@elikastelein).

dbt modeling PR template 1.0

Initial release of our dbt modeling PR template on 2020-05-20 by @ayrenay.

SQL style guide 1.0

Initial release of our SQL style guide on 2019-11-24.

dbt coding conventions 1.0

Initial release of our dbt coding conventions on 2019-11-24.