Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

tom_vanleijsen

Introduce all properties when querying materialized views in a KQL database

Submitted by Advocate I on ‎05-05-2026 03:07 AM

Return all properties of a materialized view when running:

.show materialized-views


Today only the following columns are returned:

  • Name
  • SourceTable
  • Query
  • MaterializedTo
  • LastRun
  • LastRunResult
  • IsHealthy
  • IsEnabled
  • Folder
  • DocString
  • AutoUpdateSchema
  • EffectiveDateTime
  • Lookback
  • LookbackColumn

 

But the following properties would useful as well, to have a full understanding of the materialized view:

  • DimensionTables
  • DimensionMaterializedViews
Status: New
1 Comment (1 New)
Comments
YSD
Microsoft Employee
Microsoft Employee
‎05-17-2026 01:09 AM

Thanks for your input!