Schema:: ORGANIZATION_USAGE

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).