- Schema:
MATERIALIZED_VIEW_REFRESH_HISTORY View¶
Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support.
This Account Usage view can be used to query the materialized views refresh history. The information returned by the view includes the view name and credits consumed each time a materialized view is refreshed.
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
START_TIME |
TIMESTAMP_LTZ |
Start of the specified time range. |
END_TIME |
TIMESTAMP_LTZ |
End of the specified time range. |
CREDITS_USED |
TEXT |
Number of credits billed for materialized view maintenance during the START_TIME and END_TIME window. |
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 180 minutes (3 hours).
The history is displayed in increments of 1 hour.
If you want to reconcile the data in this view with a corresponding view in the ORGANIZATION USAGE schema, you must first set the timezone of the session to UTC. Before querying the Account Usage view, execute:
ALTER SESSION SET TIMEZONE = UTC;