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://www.sunnydata.ai/blog/sql-warehouse-materialized-views-databricks
