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