2025
April
April 16, 2025 (version 0.85.0)
We’ve got exciting things happening! Here’s what’s going on this release:
Enhancements
- Inheritance fix - Previously, when you wanted a role to have access to a parent org and its child orgs, you would need to assign the role individually to each org. Now, a role assigned to a parent org automatically gets access to its child orgs.
- Limit dashboard visibility based on org assignment - Previously, all roles had access to all dashboards. Now, org roles will only see widgets and dashboards relevant to the objects assigned to their orgs.
- 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.CORTEX_ANALYST_USAGE_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.CORTEX_DOCUMENT_PROCESSING_USAGE_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.CORTEX_FINE_TUNING_USAGE_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.CORTEX_FUNCTIONS_QUERY_USAGE_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.CORTEX_FUNCTIONS_USAGE_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.CORTEX_SEARCH_DAILY_USAGE_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.CORTEX_SEARCH_SERVING_USAGE_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.DOCUMENT_AI_USAGE_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.TASK_VERSIONS
- (subset columns used:
ROOT_TASK_ID
,GRAPH_VERSION
,GRAPH_VERSION_CREATED_ON
,NAME
,ID
,DATABASE_ID
,DATABASE_NAME
,SCHEMA_ID
,SCHEMA_NAME
,OWNER
,COMMENT
,WAREHOUSE_NAME
,SCHEDULE
,PREDECESSORS
,STATE
,ALLOW_OVERLAPPING_EXECUTION
,ERROR_INTEGRATION
,LAST_COMMITTED_ON
,LAST_SUSPENDED_ON
,TARGET_COMPLETION_INTERVAL
,SCHEDULING_MODE
)
- (subset columns used:
SNOWFLAKE.ACCOUNT_USAGE.SNOWPARK_CONTAINER_SERVICES_HISTORY
(all columns)SNOWFLAKE.ACCOUNT_USAGE.PROCEDURES
(all columns)SNOWFLAKE.ACCOUNT_USAGE.AGGREGATE_QUERY_HISTORY
- (subset of columns used:
CALLS
,INTERVAL_START_TIME
,INTERVAL_END_TIME
,QUERY_PARAMETERIZED_HASH
,DATABASE_ID
,DATABASE_NAME
,SCHEMA_ID
,SCHEMA_NAME
,QUERY_TYPE
,SESSION_ID
,USER_NAME
,ROLE_NAME
,ROLE_TYPE
,WAREHOUSE_ID
,WAREHOUSE_NAME
,WAREHOUSE_SIZE
,WAREHOUSE_TYPE
,QUERY_TAG
,IS_CLIENT_GENERATED_STATEMENT
,RELEASE_VERSION
,ERRORS
,TOTAL_ELAPSED_TIME
,BYTES_SCANNED
,PERCENTAGE_SCANNED_FROM_CACHE
,BYTES_WRITTEN
,BYTES_WRITTEN_TO_RESULT
,BYTES_READ_FROM_RESULT
,ROWS_PRODUCED
,ROWS_INSERTED
,ROWS_UPDATED
,ROWS_DELETED
,ROWS_UNLOADED
,BYTES_DELETED
,PARTITIONS_SCANNED
,PARTITIONS_TOTAL
,BYTES_SPILLED_TO_LOCAL_STORAGE
,BYTES_SPILLED_TO_REMOTE_STORAGE
,BYTES_SENT_OVER_THE_NETWORK
,COMPILATION_TIME
,EXECUTION_TIME
,QUEUED_PROVISIONING_TIME
,QUEUED_REPAIR_TIME
,QUEUED_OVERLOAD_TIME
,TRANSACTION_BLOCKED_TIME
,OUTBOUND_DATA_TRANSFER_CLOUD
,OUTBOUND_DATA_TRANSFER_REGION
,OUTBOUND_DATA_TRANSFER_BYTES
,INBOUND_DATA_TRANSFER_CLOUD
,INBOUND_DATA_TRANSFER_REGION
,INBOUND_DATA_TRANSFER_BYTES
,LIST_EXTERNAL_FILES_TIME
,CREDITS_USED_CLOUD_SERVICES
,EXTERNAL_FUNCTION_TOTAL_INVOCATIONS
,EXTERNAL_FUNCTION_TOTAL_SENT_ROWS
,EXTERNAL_FUNCTION_TOTAL_RECEIVED_ROWS
,EXTERNAL_FUNCTION_TOTAL_SENT_BYTES
,EXTERNAL_FUNCTION_TOTAL_RECEIVED_BYTES
,QUERY_LOAD_PERCENT
,QUERY_ACCELERATION_BYTES_SCANNED
,QUERY_ACCELERATION_PARTITIONS_SCANNED
,QUERY_ACCELERATION_UPPER_LIMIT_SCALE_FACTOR
,CHILD_QUERIES_WAIT_TIME
,HYBRID_TABLE_REQUESTS_THROTTLED_COUNT
,OWNER_ROLE_TYPE
)
- (subset of columns used:
April 9, 2025 (version 0.84.0)
We’ve got updates! Here’s what’s happening:
Enhancements
- Timely warehouse performance alerts update - The Alerts feature has been updated to focus exclusively on two metrics: query execution time and query queueing. This update removes spillage as a metric for Alerts, as the spillage metric was causing confusion for some users. Data spillage can still be viewed on the Warehouse Performance Dashboard.
April 3, 2025 (version 0.83.0)
Slingshot updates. Here’s what’s new in this release:
Enhancements
Role name changes - Slingshot role names have been updated to clarify their scope:
Old role name New role name Org admin Snowflake admin Owner Snowflake owner Approver 1 Snowflake approver 1 Approver 2 Snowflake approver 2 Viewer Snowflake viewer Snowflake/Org admin role update - In addition, the Snowflake admin (formerly Org admin) role now has more capabilities for its assigned orgs: the configuration privileges of a Tenant admin, the action privileges of an Owner, and the review privilege of Approvers. For details, see Roles.
- You can assign/unassign users to org roles on the User Management page.
- If you wish to map or unmap LDAP groups to org roles, contact Support.
Warehouse details updates - The Warehouse details page now displays additional information and metrics, including:
- Average query execution: The average run time of queries ran over the last 30 days.
- Performance:
- Queuing & timeout: The number of queries that have entered a queue and the number of queries that have timed out.
- Bytes scanned & spill: The total bytes spilled and total number of bytes scanned.
- Queries:
- Query sizes: The total number of queries ran from 1-5 minutes, the total number of queries ran in under 1 minute, and the total number of queries ran in over 5 minutes.
- Micro-partition scanned: The total number of queries that had 100-500 partitions scanned, the total number of queries that had under 100 partitions scanned, and the total number of queries that had over 500 partitions scanned.
- Run-time: The average query run time of all queries run in the selected time period (Month, Week, Day).
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. Slingshot will leverage these tables to provide insights and recommendations for optimizing permissions and security best practices.
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.