Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Suggestions for Materialized Lake Views

Currently, there is no easy way to view the original CREATE MATERIALIZED LAKE VIEW statement or understand how an MLV was created, unless you remember the exact notebook or script it was executed from. This makes troubleshooting and collaboration difficult.

 

Additionally, there is no clear visual distinction between Delta tables and Materialized Lake Views in the UI (for example, in the Lakehouse Explorer). This makes it easy to confuse them, especially in large projects with many objects.

 

Suggestions

  •       Add a way to inspect the MLV definition, similar to how SQL views can be scripted.
  •       Introduce clearer visual indicators or icons for MLVs versus Delta tables in the Lakehouse interface.
Status: New
Comments
spellicerKUSA
Regular Visitor
Is this something beyond SHOW CREATE MATERIALIZED LAKE VIEW ? We've started using this to sync up our views from stored view definitions in our code repo