Categories:

Information Schema , Table functions

SEMANTIC_VIEW_MATERIALIZATION_REFRESH_HISTORY

Returns the refresh history for a semantic view materialization, including the state, timing, and action taken for each refresh.

See also:

Materializing dimensions and metrics in semantic views

Syntax

SEMANTIC_VIEW_MATERIALIZATION_REFRESH_HISTORY(
  NAME => '<materialization_name>'
)

Arguments

NAME => 'materialization_name'

The name of the materialization to return history for.

Output

The function returns a table with the following columns:

ColumnData typeDescription
nameTEXTName of the materialization.
schema_nameTEXTName of the schema that contains the semantic view.
database_nameTEXTName of the database that contains the semantic view.
stateTEXT

State of the refresh:

  • ACTIVE: The materialization is operational and eligible for query rewrite.
  • SUSPENDED: The materialization is suspended due to a refresh failure.
state_messageTEXTError or status message from the refresh.
refresh_start_timeTIMESTAMP_LTZTime when the refresh started.
refresh_end_timeTIMESTAMP_LTZTime when the refresh completed.
warehouseTEXTWarehouse used for the refresh.
refresh_actionTEXTAction taken during the refresh: INITIALIZE, REINITIALIZE, REFRESH, or NO_DATA.

Usage notes

  • Call this function using the TABLE() keyword in the FROM clause.
  • You must use a role that has been granted SELECT on the semantic view.

Examples

SELECT * FROM TABLE(INFORMATION_SCHEMA.SEMANTIC_VIEW_MATERIALIZATION_REFRESH_HISTORY(
  NAME => 'revenue_by_customer'
));