ALERT_HISTORY view and table function: New SCHEDULED_FROM column

Attention

This behavior change is in the 2025_02 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the ALERT_HISTORY view (in ACCOUNT_USAGE) and the output of the ALERT_HISTORY table function (in INFORMATION_SCHEMA) include the following new column:

Column nameData typeDescription
SCHEDULED_FROMTEXT

Specifies what initiated the alert. The column contains one of the following values:

  • SCHEDULE: The alert was scheduled to run normally, as described in SCHEDULE clause of CREATE ALERT.
  • EXECUTE ALERT: The alert was scheduled to run using EXECUTE ALERT.
  • TRIGGER: The alert on new data was run because the underlying table or view contains new data.

Ref: 1894