June 10-15, 2024 — 8.22 Release Notes (with behavior changes)

Attention

The release has completed.

For differences between the in-advance and final versions of these release notes, see Release notes change log.

Behavior change bundles

This release contains the following behavior change bundles:

Bundle Name

Status in this Release

Previous Status

2024_05

Disabled by default; admins can enable for testing

N/A (introduced in this release)

2024_04

Enabled by default; admins can disable for opt-out

Disabled by default

2024_03

Generally enabled; admins can no longer enable/disable

Enabled by default

The status for each bundle will change in the next behavior change release, planned for July 2024; however, this schedule is subject to change.

For more information about bundle statuses and how they may impact your accounts, see About Behavior Changes.

SQL updates

Some bitwise expression functions support BINARY data

The following bitwise expression functions now support binary data:

These functions now accept BINARY values in arguments and return BINARY values when passed binary input.

Virtual warehouse updates

Account Usage: WAREHOUSE_EVENTS_HISTORY view — General availability

With this release, we are pleased to announce the general availability of the WAREHOUSE_EVENTS_HISTORY view, which was previously available as a preview feature. The view provides a record of warehouse state changes and logs the warehouse event (for example, a warehouse suspend event) and the timestamp and reason for the event (for example, a user-initiated warehouse suspend event).

See WAREHOUSE_EVENTS_HISTORY view.

Release notes change log

Announcement

Update

Date

Release notes

Initial publication (preview)

10-Jun-24