materialized_views
materialized_views
provides information about all 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 (synchronous materialized view), ASYNC (asynchronous refresh materialized view), and MANUAL (manual refresh materialized view). When the value is ROLLUP , all fields related to activation status and refresh are empry. |
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. |