.create-or-alter materialized-view

Creates a materialized view or alters an existing materialized view.

Limitations

The command has the following limitations:

Syntax

.create-or-alter materialized-view
[ with (PropertyName = PropertyValue,...)]
ViewName on table SourceTableName
{
    Query
}

For more information on arguments and properties, see the .create materialized-view command.

Example

.create-or-alter materialized-view ArgMax on table T
{
    T | summarize arg_max(Timestamp, *) by User
}