-
Model names need to be unique in dbt (even if the files live in different directories). In a large project, you’ll end up hitting naming collisions as your project grows, so we choose to be overly verbose in our file names
-
Yep, we end up switching is last CTE out all the time when writing complex models. It’s rare that I’ll get a complex transformation right the first go, and using this workflow when debugging ends up being really useful. Of course, YMMV
(especially if you manage to write SQL correctly the first go 
)
3 Likes