ALERT_HISTORY view and table function: New SCHEDULED_FROM column (Preview)

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 name

Data type

Description

SCHEDULED_FROM

TEXT

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 streaming alert was run because the underlying table or view contains new data.

Ref: 1894

Language: English