April 17-19, 2024 — 8.15 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 |
H3_COMPACT_CELLS (Preview) |
Returns an array of VARIANT values that contain the INTEGER IDs of fewer, larger H3 cells that cover the same area as the H3 cells in the input. |
Geospatial |
H3_COMPACT_CELLS_STRINGS (Preview) |
Returns an array of VARIANT values that contain the VARCHAR hexadecimal IDs of fewer, larger H3 cells that cover the same area as the H3 cells in the input. |
Geospatial |
H3_IS_PENTAGON (Preview) |
Returns TRUE if the boundary of an H3 cell represents a pentagon. |
Geospatial |
H3_IS_VALID_CELL (Preview) |
Returns TRUE if the input represents a valid H3 cell. |
Geospatial |
H3_TRY_GRID_DISTANCE (Preview) |
A special version of H3_GRID_DISTANCE that returns NULL if an error occurs when it attempts to return the distance between two H3 cells. |
Geospatial |
H3_TRY_GRID_PATH (Preview) |
A special version of H3_GRID_PATH that returns NULL if an error occurs when it attempts to return an array of VARIANT values that contain the IDs of the H3 cells that represent the line between two cells. |
Geospatial |
H3_UNCOMPACT_CELLS (Preview) |
Returns an array of VARIANT values that contain the INTEGER IDs of H3 cells at the specified resolution that cover the same area as the H3 cells in the input. |
Geospatial |
H3_UNCOMPACT_CELLS_STRINGS (Preview) |
Returns an array of VARIANT values that contain the VARCHAR hexadecimal IDs of H3 cells at the specified resolution that cover the same area as the H3 cells in the input. |
Data loading / unloading updates¶
Support for granting the READ and WRITE privileges on external stages¶
With this release, Snowflake is pleased to announce support for granting the READ and WRITE privileges on an external stage. Previously, you could grant only the USAGE privilege on an external stage.
For more information, see Stage privileges.
Release notes change log¶
Announcement |
Update |
Date |
|---|---|---|
Release notes |
Initial publication (preview) |
16-Apr-24 |
New FAILOVER privilege for client redirect |
Removed from Replication updates section (and section removed) |
18-Apr-24 |
Support for granting the WRITE privilege on external stages |
Changed to include the READ privilege as reflected in the new title, Support for granting the READ and WRITE privileges on external stages |
22-Apr-24 |