Retrieving the KQL definition of a materialized view in the KQL database explorer

[pmscorca]

Hi,

I've need to modify some KQL materialized views, but I cannot find how I could retrieve the related KQL code inside the KQL database explorer.

Does it exist a manner to retrieve the definition of a KQL materialized view, please? Thanks

[datacoffee · Accepted solution]

You can use the 

.show materialized-view <viewname>

to get the KQL statement behind the view and also status of the view.

Also read more here: .show materialized-view command - Kusto | Microsoft Learn

[pmscorca]

Hi, ok but it is a KQL statement and not a feature of KQL database explorer.

[datacoffee]

Correct - you need to do it by code 

[v-junyant-msft]

Hi @pmscorca ,

If you want to modify your KQL materialized views, you can use this command:

.create-or-alter materialized-view

Please check this document:
https://learn.microsoft.com/en-us/kusto/management/materialized-views/materialized-view-create-or-al... 

For other commands, check these links:
Materialized views use cases - Kusto | Microsoft Learn
Materialized views - Kusto | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pmscorca]

Hi, thanks for your reply.

I've already read the documentatio about create or alter a materialized view but I'd like to find a manner in the KQL database explorer to retrieve the materialized view definition like f.e. it is possible for a view in a warehouse. Thanks