February 12-14, 2024 — 8.6 Release Notes¶
Attention
The release has completed.
For differences between the in-advance and final versions of these release notes, see Release Notes Change Log.
SQL Updates¶
New SQL functions¶
The following function(s) are now available with this release:
| Function Category | New Function | Description |
|---|---|---|
| Geospatial | ST_INTERSECTION_AGG (Preview) | Given a GEOGRAPHY column, returns a GEOGRAPHY object that represents the shape containing the combined set of points that are common to the shapes represented by the objects in the column, such as the intersection of the shapes. |
| Geospatial | ST_UNION_AGG (Preview) | Given a GEOGRAPHY column, returns a GEOGRAPHY object that represents the combined set of points that are in at least one of the shapes represented by the objects in the column, such as the union of the shapes. |
Data Loading / Unloading Updates¶
Specify an external ID for AWS storage access¶
With this release, we are pleased to announce support for specifying an external ID when you create an external volume or storage integration. Specifying an external ID lets you use the same ID to configure a trust relationship between Snowflake and AWS for multiple objects.
For more information, see:
Release Notes Change Log¶
| Announcement | Update | Date |
|---|---|---|
| Release notes | Initial publication (preview) | 12-Feb-24 |