Free Architecture Checklist

#053: What are "intermediate" models in dbt?

Oct 18, 2023

I used to hear about "intermediate" dbt models, but had no idea what they were.

Many projects (and years) later, I now finally understand their value and use them regularly on implementations.

 

In short, the idea of intermediate models (or an intermediate layer) provide a strategy for breaking up complex queries so that your models are easier to work with & understand.

When done right, they can be extremely helpful to improve readability and maintenance long term.

But used wrong and they'll just make your project a mess that will only become more difficult to manage over time.

 

So in today's video I'll break down:

  1. What "intermediate" models are
  2. Show an example use case
  3. Leave you with some tips on things to avoid

 

After this video, you'll be able to notice areas in your own project where you can improve through an intermediate layer. 

What will you learn? 

  • What it means to have intermediate models in dbt
  • How to technically add them in your project (in code)
  • Tips on ways to avoid using them the wrong way

Enjoy!

Set Your New Data Stack Up for Success with a Free Strategy Call

You’ve modernized your data architecture - now let’s ensure it’s setup for long-term success.

In this Free 30-Minute Strategy Call, we’ll:

  • Review your current setup and progress
  • Identify potential gaps or risks
  • Provide actionable next steps to optimize your process

Whether you’re managing this effort solo or with a small team, you’ll leave with a clear roadmap to confidently build a structured, scalable, and maintainable data architecture.

For best results, please provide as much detail as possible.