In the first part of this blog series, I described basic dbt® concepts such as installation, creation of views, and describing models. I could have stopped there, but indeed, there are some drawbacks to only using views to build the whole transformation layer in our database. Sometimes we don't really need to use a view and a view may run slowly even in databases oriented toward analytical workflows.
I’ll start by giving an overview of ephemeral views.
Ephemeral views
In some cases, we don't really want to have an entity for a dbt® model, rather we want this model to be inlined in oth