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

Language: English