- Schema:
MATERIALIZED_
The MATERIALIZED_VIEW_REFRESH_HISTORY view in the ORGANIZATION_USAGE schema is used for querying the materialized views refresh history for a specified materialized view within a specified date range. The information returned by the function includes the view name and credits consumed each time a materialized view is refreshed.
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_NAME | VARCHAR | Name of the account (user-defined). |
| ACCOUNT_LOCATOR | VARCHAR | Locator of the account (system-defined). |
| REGION | VARCHAR | Name of the region where the account is located. |
| USAGE_DATE | DATE | Date (in the UTC time zone) of this refresh history record. |
| CREDITS_USED | NUMBER | Number of credits billed for materialized view maintenance during the USAGE_DATE. |
| TABLE_ID | NUMBER | Internal/system-generated identifier for the materialized view. |
| TABLE_NAME | VARCHAR | Name of the materialized view. |
| SCHEMA_ID | NUMBER | Internal/system-generated identifier for the schema that contains the materialized view. |
| SCHEMA_NAME | VARCHAR | Name of the schema that contains the materialized view. |
| DATABASE_ID | NUMBER | Internal/system-generated identifier for the database that contains the materialized view. |
| DATABASE_NAME | VARCHAR | Name of the database that contains the materialized view. |
Usage notes¶
- Latency for the view may be up to 24 hours (1 day).
- The data is retained for 365 days (1 year).