#052: dbt Environments vs Targets | What's the Difference?
Oct 04, 2023As you build out your dbt project, you're inevitably going to run into the concept of environments.
But one thing that I hear from clients as well as other engineers is that it can be a bit confusing.
Especially when trying to compare configuring them on dbt Core, the open source version, to how it's done on dbt Cloud.
In short, the biggest difference is that dbt Cloud provides options through a user interface while dbt Core is all code-based.
This is also one of the main examples for why I always suggest folks learn dbt Core FIRST before moving to Cloud.
If you fully understand both, you can navigate this concept seamlessly between the different versions even though they are presented slightly different.
So in today's video I'm going to break down the differences between 3 key concepts of:
- targets
- environments
- environment variables
By the end, you'll understand the similarities and differences and feel comfortable working with these concepts regardless of which platform or version that you're using.
What will you learn?
- How to use Targets in dbt Core
- How dbt Cloud uses the concept of Environments
- Where env_vars fit in
Enjoy!
Looking for more? Here are 2 other ways I can help you:
1. Simple Stack Academy: Join 100+ students in an end-to-end, project-based training. Simple Stack Academy teaches you a 5-Step Framework to design, build & automate reliable end-to-end data architectures using modern tools like dbt & Github. Ideal for both data engineers looking to advance their careers and data team leaders looking for a clear strategy to follow.
2. Consulting Services: Get personalized support to properly implement a well-structured, scalable, and maintainable data architecture at your company. Whether starting from scratch or migrating a legacy design, you'll get custom support each step of the way to make sure it's done right.