SQL Guide¶
Language Reference¶
Language flavors (Redshift, ...)¶
Code Style¶
This SQL guide is mostly outdated. We follow corp/dbt_style_guide.md at master ยท fishtown-analytics/corp.
Most of it still applies, but:
- we don't UPPERCASE anymore, we lowercase (less code yelling at you all day)
- regarding commas: you can use leading or trailing commas, but if you're looking to wrap your head around the reasons behind one or the other, please read A Dispassionate Examination of the Empirical Evidence Regarding Positional Punctuation in SQL
SQL vs Pandas¶
Best way to play around with sql¶
SQLite
Last update:
2022-01-15