Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer
Returns failures that occurred as part of the materialization process of the materialized view.
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.
.show materialized-view MaterializedViewName failures
Learn more about syntax conventions.
| Name | Type | Required | Description |
|---|---|---|---|
| MaterializedViewName | string |
✔️ | Name of the materialized view. |
| 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. |
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 |
|---|