Incremental refresh issue in materialized views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-09-2025 04:55 AM - edited 09-09-2025 04:56 AM
i am facing the refresh issue . i am a trying to create a mv from a simple select query (select* from table where client="A") and the source table is a delta live table (streaming). The refresh is full recompute not incremental .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-09-2025 05:13 AM
There is no guarantee that MV will use incremental load. Here is a keyword from documentation - Enzyme engine will attempt to compute incrementally but this is no guarantee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-09-2025 06:34 AM
@hidden as per @szymon_dybczak 's screenshot, it needs to be serverless
All the best,
BS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2025 08:27 AM
I am using serverless sql warehouse