5 Tips for a Successful dbt Project

Jan 05, 2022

A fun part about dbt is how quickly you can get started.

But oftentimes moving fast results in subtle bad habits or, worse, compounding mistakes.

So today, I want to share with you 5 tips I've found that can help you build a successful dbt project:.

  1. Create a Staging Layer
  2. Use CTEs (Common Table Expressions)
  3. Use Directories
  4. Create a Style Guide
  5. Don't Optimize for Fewer Lines

 

These might seem overly-obvious, yet many teams miss some (or all) of these completely.

Rather than talk more about them in text, I think it's more helpful to discuss in video form.

I've put together a short video talking about each of these 5 tips and why you should care about them.

Enjoy.

THE SIMPLE STACK AUDIT

Get a 36-point second opinion on your data architecture. 

For data leaders on small (or one-person) teams who make every data decision alone.

Know what you got right, what to fix & what to build next.


Schedule a 30-minute intro call to see if it's the right fit for you.

You'll pick a date/time on the next page once submitted.