.show materialized-view failures

Applies to: ✅ Microsoft FabricAzure Data Explorer

Returns failures that occurred as part of the materialization process of the materialized view.

Permissions

You must have at least Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.

Syntax

.show materialized-view MaterializedViewName failures

Learn more about syntax conventions.

Parameters

Name Type Required Description
MaterializedViewName string ✔️ Name of the materialized view.

Returns

Name Type Description
Timestamp datetime Date and time when the failure occurred.
OperationId string Operation identifier of the run that failed.
Name string Name of the materialized view.
LastSuccessRun datetime Date and time of the last run that completed successfully.
FailureKind string Type of failure (Permanent/Transient).
Details string Details of the failure.

Examples

Show failures occurred during materialization of a materialized view

The following command shows the failures, if any, occurred during the materialization of materialized view ViewName:

.show materialized-view ViewName failures

Output

Timestamp OperationId Name LastSuccessRun FailureKind Details