2025
March
March 19, 2025 (version 0.81.0)
We’ve got updates! Here’s what’s new:
Enhancements
Updated warehouse performance notifications -
In order to have more confidence in the quality of Slingshot’s schedule recommendations, you can now set custom performance thresholds to alert you (and/or any of your team members) if a warehouse has experienced any unexpected spikes in three key performance metrics: query queuing, query execution time, and spillage. You will be able to configure an alert in the following three locations:- After applying a recommendation, a modal will pop up asking if you want to set a performance alert on that warehouse - this allows you to ensure the new warehouse schedule is not performing anomalously.
- You can create or manage alerts for any warehouse at any time on the Warehouses page.
- As a tenant admin, you can create alerts for groups of warehouses that are assigned to the same tag(s) in the Configurations page.
Updated My Warehouses details -
- Warehouses table updates:
- We now have an updated Warehouses table that unifies all of your warehouses in one place. View current monthly cost, management status, and Query Acceleration Service (QAS) status inside the table. Filter by important attributes, such as available recommendations, alerts, and orgs.
- Get quick insights into which warehouses have available optimizations, or have triggered alerts through updated icons attached to each warehouse in the table.
- Export the list of warehouses in the table for analysis outside of Slingshot.
- Warehouse details updates:
- Get quick insights into the status of your warehouse including the cost and query runs over the last 30 days.
- Analyze deeper using the dashboard widget by applying custom date ranges and specified time increments.
- View the current settings and schedule of the warehouse, or view warehouse history and revert to previous settings.
- Warehouses table updates:
Updated Metadata Share - We are working on new features that will rely on tables we haven’t used previously. To support these features, we’re ingesting additional metadata from the already approved Snowflake Secure Data Share used by Slingshot. During our metadata ingestion, we’re adding the following tables to our sync, and you may see a one-time pull of the last 30-days of historical data.
SNOWFLAKE.ACCOUNT_USAGE.SNOWPIPE_STREAMING_FILE_MIGRATION_HISTORY
(all columns)SNOWFLAKE.ORGANIZATION_USAGE.REPLICATION_USAGE_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.QUERY_ACCELERATION_HISTORY
(subset of columns used:START_TIME
,WAREHOUSE_ID
,CREDITS_USED
,END_TIME
,WAREHOUSE_NAME
)SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY
( subset of columns used:CREDITS_USED_COMPUTE
,CREDITS_USED_CLOUD_SERVICES
)SNOWFLAKE.ACCOUNT_USAGE.USERS
(subset of columns used:USER_ID
,NAME
,CREATED_ON
,DELETED_ON
)SNOWFLAKE.ACCOUNT_USAGE.USERS.GRANTS_TO_USERS
(all columns)SNOWFLAKE.ACCOUNT_USAGE.USERS.GRANTS_TO_ROLES
(all columns)
February
February 26, 2025 (version 0.78.0)
We’ve got updates! Here’s what’s new:
Enhancements
- Warehouse-level results in Value Reports -
- The Value Report now shows savings at a per Warehouse level.
- A new table is available in the Value Report, showing how much money your organization has saved on each Warehouse recommendation applied and how much the query load on each of those Warehouses has changed.
- For a given month, the table shows all recommendations applied in the last month, and shows queries run, costs, and savings for each.
- Updated Metadata Share - We are working on new features that will rely on tables we haven’t used previously. To support these features, we’re ingesting additional metadata from the already approved Snowflake Secure Data Share used by Slingshot. During our metadata ingestion, we’re adding the following tables to our sync, and you may see a one-time pull of the last 30-days of historical data.
SNOWFLAKE.ACCOUNT_USAGE.SESSIONS
(all columns)SNOWFLAKE.ACCOUNT_USAGE.TASK_HISTORY
(excludingQUERY_TEXT
)SNOWFLAKE.ACCOUNT_USAGE.DYNAMIC_TABLE_REFRESH_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.TABLE_PRUNING_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.QUERY_ATTRIBUTION_HISTORY
(all columns)
February 5, 2025 (version 0.75.0)
We’ve got updates! Here’s what’s new:
Enhancements
- Self-service org role management - This feature is now enabled if you are on SSO. Tenant admins can now manage orgs on the Manage Slingshot Tags page and assign user roles (Org admin, Owner, Viewer, and Approver 1) on the User management page. For more information, see:
January
January 29, 2025 (version 0.74.0)
We’ve got updates! Here’s what’s new:
Enhancements
- Self-service org role management - This feature is now enabled if you are a full customization tenant. Tenant admins can now manage orgs on the Manage Slingshot Tags page and assign user roles (Org admin, Owner, Viewer, and Approver 1) on the User management page. For more information, see:
January 15, 2025 (version 0.72.0)
We’re kicking off the new year with some updates! Here’s what’s new:
Enhancements
- Display queries with Query Advisor suggestions - Upon entering the Query Advisor page, users will now see an indicator for each query that has one or more opportunities for optimization. This prevents them from having to analyze each query one-by-one to discover these opportunities. Users will also be able to filter the page to show only the queries with opportunities for optimization.