Query rewrite suggestions

Date
  • Alan Cruickshank
    Alan Cruickshank
    Software Engineer at SELECT
  • Jonathan Talmi
    Jonathan Talmi
    Product Engineer @ SELECT

To help provide users with more actionable optimization insights, we’ve improved our Insights feature by adding suggested query changes. For example, if a workload is not pruning well (scanning too much data) we will share suggestions on how you can add filtering on high cost table scans to force query pruning.

SELECT Query Rewrite Suggestions

These insights will be surfaced at both the workload level and on individual queries.

Other Things We Shipped

  • 🐛 Fixed bug causing short-lived Snowflake views to be missing from Lineage
  • 🪄 Improvements for saved views across all pages and permissions around saved views

Get up and running with SELECT in 15 minutes.

Snowflake optimization & cost management platform

Gain visibility into Snowflake usage, optimize performance and automate savings with the click of a button.

SELECT web application screenshot