- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-09-2025 02:26 AM
When creating a Materialized View (MV) without a schedule, there seems to be a cost associated with the MV once it is created, even if it is not queried.
The question is, once the MV is created, is there already a "hot" compute ready for use in case ad-hoc refreshes of the MV occur?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-09-2025 09:40 AM
When a Materialized View (MV) is created in Databricks without a refresh schedule, there is no “hot” compute automatically kept ready for ad-hoc refreshes. However, the MV incurs costs associated with storage (vendor cost) because it physically stores precomputed query results in a table-like structure. In short, a materialized view is a table that incurrs cost when it is created or modified. However, once it is sitting in place (cloud storage) there are no Databricks charges, unless of course you are modifying it or accessing it via Spark (reads, optimizations, etc). Hope this helps. Lou.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-10-2025 04:09 AM
Thanks for the clarification, much appreciated !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-10-2025 07:14 AM
Please select "Accept as Solution" so that others can benefit from this exchange. Regards, Louis.