Snowflake Release Notes
September 2024
Last updated:
What's New
Multi-Account support
With this release, Unravel supports monitoring multiple Snowflake accounts. Users can now configure and monitor cost and performance across multiple accounts.
Enhanced RBAC support
This release enables administrators to create custom roles with specific permissions, offering granular control over user access to Unravel features. Administrators can now:UI functionality and visibility are automatically adjusted based on assigned roles, further enhancing RBAC support and improving security and visibility.
Create custom roles.
Add new users.
Map users to roles.
Query Analyzer app
This release introduces the Query Analyzer app store app to help users check their queries for potential cost and performance issues before executing them in Snowflake. The app allows users to proactively analyze SQL queries for potential cost and performance issues before running them on Snowflake. Key features of this app include:
Pre-execution analysis of SQL queries to detect cost and performance concerns.
Provides actionable insights and optimization suggestions to improve efficiency.
Snowflake Tags in Unravel
You can now create tags in Snowflake to label queries and objects, such as tables, databases, and warehouses. You can create custom dashboards based on these tags to analyze cost, performance, and storage utilization across queries and objects.
Improvements
Storage Policies
You can now configure new storage policies for better control of data retention and recovery. The following storage policies are available with this release:
Time travel policy: Identifies tables that violate the conditions. of the configured time travel policy.
Clone policy: Identifies tables that have many clones.
Cold transient, table policy: Supports temporary storage for infrequently accessed data.
Fail-safe policy: Identifies tables that violate the conditions of the configured fail-safe policy..
ID | Description |
|---|---|
SNOW-2388 | Query insight names should not be truncated in the filter. |
SNOW-2558 | Usernames are being converted to uppercase in the Query Details page. The username should be displayed as it appears in the query. |
SNOW-2563 | The HomePage displays the analysis for 14 days. It should also display data for 7 days. |
SNOW-2571 | Data table events are being trimmed unexpectedly. |
SNOW-2600 | The date parameter is not being passed when calling the right-sizing of warehouses API on the Home page. |
SNOW-2607 | The warehouse count incorrectly includes "Cloud Services Only," which should be skipped as it is not a warehouse. |
SNOW-2625 | The Copy button on the Queries page is not working as expected. |
ID | Description |
|---|---|
SNOW-2725 | The Most Expensive Warehouse table stops displaying data for other configured accounts when a user sorts any column. |
SNOW-2769 | The Health Check report is being generated even for accounts that have been removed. |
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.