April 01-03, 2024 — 8.13 Release Notes¶

Evaluation Metrics for Forecasting and Anomaly Detection¶

With this release, we are pleased to introduce training-time evaluation metrics for Anomaly Detection, a member of the Snowflake Cortex ML Functions suite, similar to those supported for the Forecasting and Classification ML Functions. The Forecasting and Anomaly Detection functions can now also calculate evaluation metrics on new data, so that you can easily compare forecasts to actual observations. These tools allow you to easily determine how well the model predicts real data. For more information, see:

• Anomaly Detection: Show Evaluation Metrics

• Forecasting: Show Evaluation Metrics

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

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.