5 ms·

Don't views and materialized views give you reuse? Can't you do composibility with foreign references?

• neurocean 6y ago
  Sure, while views may be fine for small projects, using them for larger projects like data warehousing is usually a mistake you'll come to regret. SQL views are rarely unit tested so you always end up in a regression nightmare when you need to make updates. If you're going to go pure SQL, you should use something like dbt.