ACCOUNT_USAGE.ONLINE_FEATURE_TABLE_REFRESH_HISTORY

This Account Usage view displays information for online feature table refresh history.

See also:

ONLINE_FEATURE_TABLE_REFRESH_HISTORY (Information Schema)

Columns

ColumnData typeDescription
NAMETEXTName of the online feature table.
SCHEMA_NAMETEXTName of the schema that contains the online feature table.
DATABASE_NAMETEXTName of the database that contains the online feature table.
QUALIFIED_NAMETEXTFully qualified name of the online feature table.
STATETEXT

Status of the refresh for the online feature table. The status can be one of the following:

  • EXECUTING: refresh in progress.
  • SUCCEEDED: refresh completed successfully.
  • FAILED: refresh failed during execution.
  • CANCELLED: refresh was canceled before completion.
STATE_CODETEXTCode representing the current state of the refresh.
STATE_MESSAGETEXTDescription of the current state of the refresh.
REFRESH_START_TIMETIMESTAMP_LTZTime when the refresh job started.
REFRESH_END_TIMETIMESTAMP_LTZTime when the refresh completed.
REFRESH_TRIGGERTEXT

One of:

  • SCHEDULED: normal background refresh to meet target lag.
  • MANUAL: user/task ran ALTER ONLINE FEATURE TABLE <name> REFRESH command.
  • CREATION: refresh performed during the creation DDL statement, triggered by the creation of the online feature table.
REFRESH_ACTIONTEXT

One of:

  • NO_DATA: no new data in base tables. Doesn’t apply to the initial refresh of newly created online feature tables regardless of whether or not the base tables have data.
  • REINITIALIZE: base table changed.
  • FULL: Full refresh, because refresh mode of the online feature table is set to FULL.
  • INCREMENTAL: normal incremental refresh.

Usage notes

  • Online Feature Table refresh history in this view may lag by up to 3 hours.
  • To query this view, use a role that is granted the SNOWFLAKE database role USAGE_VIEWER.
  • The ONLINE_FEATURE_TABLE_REFRESH_HISTORY function offers up-to-date refresh history.

Access control requirements

PrivilegeObjectNotes
USAGE_VIEWER database roleSNOWFLAKE databaseRequired to query Account Usage views.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.