WAREHOUSE_EVENTS_HISTORY view (ACCOUNT_USAGE): New columns and changes to events

Attention

This behavior change is in the 2024_04 bundle.

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

When this behavior change bundle is enabled, the Account Usage WAREHOUSE_EVENTS_HISTORY view changes as follows.

New columns

The following new columns are added to the view:

Column Name

Data Type

Description

SIZE

VARCHAR

Current size of the warehouse at the time of the event. This value is only available for WAREHOUSE_CONSISTENT events. Otherwise, this value is NULL.

CLUSTER_COUNT

NUMBER

Number of warehouse clusters at the time of the event. This value is only available for WAREHOUSE_CONSISTENT events. Otherwise, this value is NULL.

These columns are added as the last (right-most) columns in the view.

New event: WAREHOUSE_CONSISTENT

Events that create a warehouse, change the size of the warehouse or the number of clusters, or suspend a warehouse, are not atomic operations. This means that some small amount of time is required for these operations to fully complete.

For example, if a warehouse is suspended using an ALTER WAREHOUSE … SUSPEND statement, any queries that are currently executing on the warehouse must complete (or time out) before it can be suspended. In some cases, multiple warehouse events might be in-flight (for example, resize and suspend). When all warehouse events have completed, the warehouse is in a consistent state.

EVENT_NAME

Description

WAREHOUSE_CONSISTENT

This state is reached when any pending changes to a warehouse are completed.

Changes to events

When this behavior change bundle is enabled, the event state PARTIALLY_COMPLETED is obsoleted.

If an event is logged with the STARTED state, it is never logged with the COMPLETED state. Instead, an event logged with the STARTED state is always followed by a subsequent WAREHOUSE_CONSISTENT event. If multiple warehouse events are logged with the STARTED event state, those events coalesce to the same WAREHOUSE_CONSISTENT event.

If an event is logged with the COMPLETED state, no subsequent WAREHOUSE_CONSISTENT event follows unless another pending event is logged with a STARTED state.

For example, an ALTER statement is logged with the COMPLETED state when there are no additional changes pending:

ALTER WAREHOUSE my_wh SET
  COMMENT = 'Updated comment for warehouse';
Copy

This statement results in the following row in the WAREHOUSE_EVENTS_HISTORY view:

TIMESTAMP

WAREHOUSE_NAME

EVENT_NAME

EVENT_STATE

SIZE

CLUSTER_COUNT

2024-04-26 16:42:13.513 +0000

MY_WH

ALTER_WAREHOUSE

COMPLETED

NULL

NULL

When an ALTER statement changes the warehouse size, a resize warehouse event follows:

ALTER WAREHOUSE my_wh SET
  WAREHOUSE_SIZE = 'SMALL';
Copy

This statement results in the following rows in the WAREHOUSE_EVENTS_HISTORY view:

TIMESTAMP

WAREHOUSE_NAME

EVENT_NAME

EVENT_STATE

SIZE

CLUSTER_COUNT

2024-04-26 16:42:35.694 +0000

MY_WH

ALTER_WAREHOUSE

STARTED

NULL

NULL

2024-04-26 16:42:35.694 +0000

MY_WH

RESIZE_WAREHOUSE

STARTED

NULL

NULL

2024-04-26 16:42:35.773 +0000

MY_WH

WAREHOUSE_CONSISTENT

COMPLETED

SMALL

1

Note that the WAREHOUSE_CONSISTENT event might share the same timestamp with another warehouse event and be listed out of order.

The possible values for the EVENT_STATE column for warehouse events changes as follows:

EVENT_NAME

EVENT_STATE before the change

EVENT_STATE after the change

CREATE_WAREHOUSE

COMPLETED

COMPLETED if no further changes are pending, otherwise STARTED.

In most cases, followed by a RESUME_WAREHOUSE event.

DROP_WAREHOUSE

COMPLETED

COMPLETED if no further changes are pending, otherwise STARTED.

In most cases, followed by a SUSPEND_WAREHOUSE event.

ALTER_WAREHOUSE

COMPLETED

COMPLETED if no further changes are pending, otherwise STARTED if the ALTER statement results in an eventually consistent event to follow.

RESIZE_WAREHOUSE

STARTED, . COMPLETED, . PARTIALLY_COMPLETED

STARTED

RESUME_WAREHOUSE

STARTED, . COMPLETED, . PARTIALLY_COMPLETED

STARTED

SUSPEND_WAREHOUSE

STARTED, . COMPLETED, . PARTIALLY_COMPLETED

STARTED

RESUME_CLUSTER

COMPLETED

STARTED

SUSPEND_CLUSTER

COMPLETED

STARTED

RESIZE_CLUSTER

COMPLETED

STARTED

SPINUP_CLUSTER

STARTED, . COMPLETED, . PARTIALLY_COMPLETED

STARTED

SPINDOWN_CLUSTER

STARTED, . COMPLETED, . PARTIALLY_COMPLETED

STARTED

Ref: 1616