1. 1. Intro
  2. 2. πŸ› οΈ Dev Tools
  3. 3. πŸ—οΈ Structure & Styling
  4. 4. πŸŽ‹ Branching
  5. 5. πŸ“ Pre-commit
  6. 6. πŸͺ‘ CI/CD
  7. 7. Lint and format
  8. 8. Managing YMLs
  9. 9. 🧰 Troubleshooting
  10. 10. πŸ›³οΈ Deployment
  11. 11. πŸ§ͺ Testing
  12. 12. ☁️ dbt Cloud
  13. 13. ☁️ Paradime.io
  14. 14. πŸ’° Cost Monitoring
  15. 15. Platforms
    1. 15.1. ❄️ Snowflake
      1. 15.1.1. πŸ”§ Setup
      2. 15.1.2. πŸ—οΈ Architecture Overview
      3. 15.1.3. πŸ’Ύ Storage
        1. 15.1.3.1. πŸ›‘οΈ Table Types
        2. 15.1.3.2. πŸ—„οΈ Data Protection & Retention
        3. 15.1.3.3. 🧩 Snowflake-specific advanced features
      4. 15.1.4. βš™οΈ Compute
        1. 15.1.4.1. πŸ“‹ Overview
        2. 15.1.4.2. βš™οΈ Warehouses: Sizing and Threads
        3. 15.1.4.3. πŸ—‚οΈ Clustering and Micro-partitions
        4. 15.1.4.4. πŸš€ Other Serverless Features
      5. 15.1.5. 🧩 Special SQL Features
      6. 15.1.6. πŸ”Ž Monitoring & Debugging
    2. 15.2. πŸ” BigQuery
      1. 15.2.1. Python Models
    3. 15.3. πŸš— Redshift
    4. 15.4. 🧱 Databricks
  16. 16. Contributing

πŸ—οΈ How we structure and style our projects

We follow theΒ Matt Mazur SQL style guideΒ and the one byΒ Fishtown Analytics for dbt-specific behaviors.

We also follow theΒ best practices documented on the dbt website.

We LOVE CTEs, we don’t use subqueries!

We LOVE trailing commas!

Find a good project checklist here

Other great resources to check out

  • How we structure our dbt projects
  • How we configure Snowflake
  • The Ultimate Guide to Using dbt With Snowflake
  • Snowflake-Terraform-bootstrap project
  • How to set up a dbt data-ops workflow, using dbt cloud and Snowflake