Incremental refresh issue in materialized views

hidden
New Contributor II

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 .

szymon_dybczak
Esteemed Contributor III

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

szymon_dybczak_0-1757419971816.png

 

BS_THE_ANALYST
Databricks Partner

@hidden  as per @szymon_dybczak 's screenshot, it needs to be serverless

All the best,
BS

I am using serverless sql warehouse