你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
.show materialized-view failures
Applies to: ✅ Microsoft Fabric ✅ Azure 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 |
|---|