cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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 .

3 REPLIES 3

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
Esteemed Contributor II

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

All the best,
BS

I am using serverless sql warehouse 

 

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now