If you are using dbt and working with a new or existing project, having a guideline to follow in order to create and organize your models is very important. This is crucial if your dbt project becomes bigger and bigger. In this scenario, having a weak project's structure could cause your project to become very hard to understand and work on.
When working with dbt models, you should know three main model types: staging (also named base), intermediate, and marts. In a small dbt project, you could not hear about intermediate models because few intermediate transformations and modeling need to be performed.
In this lab, you will understand what the three model types mentioned above mean, you will then create some dbt models and organize them following the best practices. You will finally build the dbt project to get the models built.
Upon completion of this lab, you will be able to:
To get the most from this lab, you should have basic knowledge of dbt. To get ready, you can use the following labs: