Materialized views running on SQL warehouse are super cost-efficient, and additionally, it is a really simple and powerful data engineering tool - just be sure that Enzyme updates it incrementally.
Read more:
- https://databrickster.medium.com/sql-warehouse-a-materialized-view-is-the-simplest-and-cost-efficien...
- https://www.sunnydata.ai/blog/sql-warehouse-materialized-views-databricks

My blog: https://databrickster.medium.com/