Snowflake Release Notes
June 2024
Last updated: June 17, 2024
What's New
Home page
A new Home page is introduced, which automatically provides a daily health check of your past 7 or 14-day workload. The Home page contains the following sections:
Usage and Cost Breakdown: View an overview of usage and cost.
Productivity, Cost, and Performance Improvements: Receive recommendations for increasing productivity, reducing cost wastage, and enhancing performance.
Summary of Inefficiencies: Get insights into inefficiencies, their impact, untapped savings, and performance improvements with specific recommendations for warehouses, queries, storage, and operations.
CI/CD Integration: Track how many Unravel recommendations from your CI/CD have been accepted and how many have not been.
Out-of-the-box Alerts: Receive daily reports on the number of violations directly on the Home page without configuring or enabling notifications.
CI/CD Integration
View Unravel recommendations directly in your CI/CD pipeline. Accept recommendations to save costs and improve performance.
Anomaly Detection Dashboard
Utilize the new anomaly detection dashboard to define, configure, preview detectors, and view anomaly detection results.
Improvements
Insights
Query Insights
View line numbers showing where issues occur within queries.
Two new query insights are added:
Usage of functions in predicates.
Move queries to smaller warehouses to save costs.
Storage Insights
A new storage insight added: Detect anomalous table size changes to identify and address storage issues.
ID | Description |
|---|---|
CPLANE-3614 | Breaking change in SQLAlchemy prevents audit logs from being written to the database. |
SNOW-2130 | Mismatch in insights count on queries page and query details page. |
Last updated: February 9, 2024
What's New
Secured data share
Unravel leverages the Snowflake secured data share (Snow Share) option for data transfer over shared connections outside the Virtual Private Cloud (VPC) or through private links. This involves employing a serverless/warehouse task to independently replicate metadata to the schema in the customer Snowflake account, allowing you to share metadata directly with the Unravel Snowflake account in the same region.
Scaling optimization
A scaling optimization approach is introduced in this release, which aims to optimize the efficiency of pipeline processing for Snowflake query data, ultimately enhancing the performance of the Queries page on Unravel UI.
By employing the scaling optimization method, Unravel effectively queried a minimum of 1.5 million records in 43 minutes and a maximum of 11.2 million records within 4 hours 34 minutes. A deviation of 15% can be anticipated.
For a detailed breakdown, refer to the following table, which presents the examined number of records and their respective polling times in hours.
Number of records (Million)
Polling time in hours
1.5 M
0.72
3.4 M
0.93
5.7 M
2.51
8.2 M
3.26
11.2 M
4.58
With the growing volume of records, you can anticipate a proportional increase in processing time. As the dataset expands, there is an impact on the time required for efficient processing. Alternatively, scaling up the hardware is a viable and recommended strategy to mitigate latency challenges associated with larger record processing.
Improvements
Query details page
Facility is provided to expand the query text box. (UIX-6460)
Copy button is provided for copying the query for every query comparison. (UIX-6463)
Facility is provided for a side-by-side comparison of the query text. (UIX-6464)
Updated the content for the Review usage of Union event. (SNOW-1408)
Add more metrics in side-by-side query comparison. (UIX-6466)
Warehouse
Text updated for the Consolidate warehouse event to mention autoscaling. (SNOW-1410)
Changed the default time range for cost and warehouse load from 8 hours to 7 days.(UIX-6474)
Bugfixes
Warehouse
Warehouse size information is missing for some warehouses. (SNOW-1474)
In the Warehouse details page, the warehouses with UNKOWN/DELETED status have incorrect dates for the Resumed On field. (SNOW-1381)
Unable to read the warehouse_id for the warehouse. (SNOW-1566)
Insights
The top 5 warehouse Insights section shows more than five insights. (SNOW-1406)
Polling
Fixed the java. lang.NullPointerException in snowflake_worker that was observed while polling. (SNOW-1517)
Cost
Cost data is not shown on the Cost > Overview page for a few days. (SNOW-1556)
Known issues
Insights
Warehouse insights are generated for warehouses that are dropped and whose status is UNKOWN (SNOW-1377)
Snowflake archived release notes
Refer to Archived 4.8x Snowflake release notes.