materialized_views
materialized_views provides information about all asynchronous materialized views.
The following fields are provided in materialized_views:
| Field | Description |
|---|---|
| MATERIALIZED_VIEW_ID | ID of the materialized view. |
| TABLE_SCHEMA | Database in which the materialized view resides. |
| TABLE_NAME | Name of the materialized view. |
| REFRESH_TYPE | Refresh type of the materialized view. Valid values: ROLLUP, ASYNC, and MANUAL. |
| IS_ACTIVE | Indicates whether the materialized view is active. Inactive materialized views cannot be refreshed or queried. |
| INACTIVE_REASON | The reason that the materialized view is inactive. |
| PARTITION_TYPE | Type of partitioning strategy for the materialized view. |
| TASK_ID | ID of the task responsible for refreshing the materialized view. |
| TASK_NAME | Name of the task responsible for refreshing the materialized view. |
| LAST_REFRESH_START_TIME | Start time of the most recent refresh task. |
| LAST_REFRESH_FINISHED_TIME | End time of the most recent refresh task. |
| LAST_REFRESH_DURATION | Duration of the most recent refresh task. |
| LAST_REFRESH_STATE | State of the most recent refresh task. |
| LAST_REFRESH_FORCE_REFRESH | Indicates whether the most recent refresh task was a force refresh. |
| LAST_REFRESH_START_PARTITION | Starting partition for the most recent refresh task. |
| LAST_REFRESH_END_PARTITION | Ending partition for the most recent refresh task. |
| LAST_REFRESH_BASE_REFRESH_PARTITIONS | Base table partitions involved in the most recent refresh task. |
| LAST_REFRESH_MV_REFRESH_PARTITIONS | Materialized view partitions refreshed in the most recent refresh task. |
| LAST_REFRESH_ERROR_CODE | Error code of the most recent refresh task. |
| LAST_REFRESH_ERROR_MESSAGE | Error message of the most recent refresh task. |
| TABLE_ROWS | Number of data rows in the materialized view, based on approximate background statistics. |
| MATERIALIZED_VIEW_DEFINITION | SQL definition of the materialized view. |