September 30 - October 03, 2024 — 8.37 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
Semi-structured and structured data	REDUCE	Reduces an array to a single value based on the logic in a lambda expression.
Geospatial	ST_INTERPOLATE	Given an input GEOGRAPHY object, returns an interpolated object that is within a specified tolerance. You can call this function when you need to see how GEOGRAPHY objects look like in the planar coordinate system (for example, when using visualization tools for geospatial data).

Function category

New function

Description

Semi-structured and structured data

REDUCE

Reduces an array to a single value based on the logic in a lambda expression.

Geospatial

ST_INTERPOLATE

Given an input GEOGRAPHY object, returns an interpolated object that is within a specified tolerance.

You can call this function when you need to see how GEOGRAPHY objects look like in the planar coordinate system (for example, when using visualization tools for geospatial data).

Extensibility updates¶

Authentication with AWS IAM from procedures and functions — Preview¶

With this release, we are pleased to announce preview support for authenticating with AWS services from a procedure or functions using Snowpark External Access via Identity and Access Management (IAM).

For more information, see Accessing Amazon S3 with AWS IAM.

Release notes change log¶

Announcement	Update	Date
Release notes	Initial publication (preview)	27-Sep-24