September 27-29, 2023 — 7.34 Release Notes (with behavior changes)¶
Behavior Change Bundles¶
This release contains the following behavior change bundles:
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.