.show materialized-view failures
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 |
|---|