April 01-03, 2024 — 8.13 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

Fixed an issue with the PARSE_IP function

Previously, the PARSE_IP function would parse the following types of invalid IP addresses:

  • IPv4 addresses with less than 4 parts

  • IPv6 addresses with more than 4 hex digits in a single part

For example, the PARSE_IP function returned results for the following queries:

SELECT PARSE_IP('1.1.1', 'inet');
SELECT PARSE_IP('1::abcde', 'inet');
Copy

This issue has been fixed, and the PARSE_IP function now returns an error for these types of invalid IP addresses.

Fixed an issue with the SPLIT_PART function

Previously, the SPLIT_PART function ignored trailing spaces when all of the following conditions were met:

  • All inputs were constants.

  • The string to split ended with the delimiter.

  • The partNumber value was negative.

For example, the SPLIT_PART function returned the following results:

SELECT SPLIT_PART('/a/b/c/', '/', -1);

+--------------------------------+
| SPLIT_PART('/A/B/C/', '/', -1) |
|--------------------------------|
| c                              |
+--------------------------------+

SELECT SPLIT_PART('/a/b/c/', '/', -2);

+--------------------------------+
| SPLIT_PART('/A/B/C/', '/', -2) |
|--------------------------------|
| b                              |
+--------------------------------+
Copy

This issue has been fixed, and the SPLIT_PART function now returns the correct results under these conditions. For example, the SPLIT_PART function now returns the following results:

SELECT SPLIT_PART('/a/b/c/', '/', -1);

+--------------------------------+
| SPLIT_PART('/A/B/C/', '/', -1) |
|--------------------------------|
|                               |
+--------------------------------+

SELECT SPLIT_PART('/a/b/c/', '/', -2);

+--------------------------------+
| SPLIT_PART('/A/B/C/', '/', -2) |
|--------------------------------|
| c                              |
+--------------------------------+
Copy

Extensibility updates

Access to Git repositories from Snowflake — Preview

With this release, we are pleased to announce the public preview of access to Git repositories from within Snowflake. After you configure Snowflake to act as a client of your Git repository, you can fetch a full clone of your remote repository to a Snowflake repository stage, which represents a local repository. You can reference these fetched files in procedure and function handler code, execute SQL and Python code in Snowflake, copy file contents into Snowflake worksheets, and more.

For more information, see Using a Git repository in Snowflake.

Release notes change log

Announcement

Update

Date

Release notes

Initial publication (preview)

01-Apr-24