.create-or-alter materialized-view

Creates a materialized view or alters an existing materialized view.

Limitations

The command has the following limitations:

• See limitations in alter materialized view limitations.
• The backfill property isn't supported if the materialized view already exists. If the materialized view already exists, it cannot be backfilled.
• You must either be the database user who created the materialized view or have database admin permission to run this command.

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
}