September 27-29, 2023 — 7.34 Release Notes (with behavior changes)

Behavior Change Bundles

This release contains the following behavior change bundles:

Bundle Name

Status in this Release

Previous Status

2023_07

Disabled by default; admins can enable for testing

N/A (introduced in this release)

2023_06

Enabled by default; admins can disable for opt-out

Disabled by default

2023_05

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 October; however, this schedule is subject to change.

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

New Features

Snowflake Alerts — General Availability

With this release, we are pleased to announce the general availability of Snowflake Alerts. A Snowflake Alert is a schema-level object that you can use to send a notification or perform an action when data in Snowflake meets certain conditions.

For example, you can set up a Snowflake Alert to send a notification or perform an action when:

  • The warehouse credit usage increases by a specified percentage of your current quota.

  • The resource consumption for your pipelines, tasks, materialized views, etc. increases beyond a specified amount.

  • Your data fails to comply with a particular business rule that you have set up.

For more information, see Setting up alerts based on data in Snowflake.

SQL Updates

New SQL Functions

The following function(s) are now available with this release:

Function Category

New Function

Description

Semi-Structured Data Functions (Array/Object)

ARRAY_FLATTEN

Flattens an ARRAY of ARRAYs into a single ARRAY.

Web Interface Updates

Allow Snowflake On Demand customers to purchase listings

With this release, we are pleased to announce that Snowflake On Demand customers can now purchase listing. For pricing information please see Snowflake Pricing.

Customers with trial accounts will still need to convert to paid accounts to purchase listings.

For a list of supported countries, see Where paid listings are available to consumers.