Snowflake Release Notes
February 2024
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.