topic Incremental refresh issue in materialized views in Get Started Discussions

Incremental refresh issue in materialized views

hidden — Tue, 09 Sep 2025 11:56:04 GMT

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 .

Re: Incremental refresh issue in materialized views

szymon_dybczak — Tue, 09 Sep 2025 12:13:20 GMT

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

Re: Incremental refresh issue in materialized views

BS_THE_ANALYST — Tue, 09 Sep 2025 13:34:29 GMT

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

All the best,
BS

Re: Incremental refresh issue in materialized views

tenzinpro — Wed, 10 Sep 2025 15:27:45 GMT

I am using serverless sql warehouse