- Schema:
MATERIALIZED_VIEW_REFRESH_HISTORY View¶
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 where the usage took place. |
ACCOUNT_NAME |
TEXT |
Name of the account where the usage took place. |
ACCOUNT_LOCATOR |
TEXT |
Name of the account locator. |
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 |
TEXT |
Name of the materialized view. |
SCHEMA_ID |
NUMBER |
Internal/system-generated identifier for the schema that contains the materialized view. |
SCHEMA_NAME |
TEXT |
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 |
TEXT |
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).