View full changelog

Analyze read/write workloads for your Snowflake tables

Date
  • Niall Woodward
    Co-founder & CTO of SELECT

We’re excited to show off some new capabilities we’ve released to help you analyze the different workloads running against your Snowflake tables.

In the Workloads tab on the tables page, you are now able to easily switch between read and write workloads.

Read workloads show you all workloads that are accessing data in the table.

Snowflake queries reading from a table

Write workloads are those that perform some DML operations against the table (i.e. an insert, update, delete, etc).

Snowflake queries writing to a table

We’ve also shipped a new Query Performance tab which gives you a number of helpful views out of the box. Learn how often a table is being queried, the cost of those queries, and how well they are pruning.

Snowflake table read performance stats

For write workloads, in addition to cost details, you’ll be able to see information about how much data is being added to/removed from a table. This is very important to understand when making decisions around automatic clustering, as this will have a significant impact on costs. If a high portion of a table is being updated/re-written every day, automatic clustering costs will be higher since Snowflake will frequently have to re-sort the same data over and over.

Snowflake table write performance stats

Not available for Snowflake Standard Edition Customers

This feature relies on the Snowflake access history view which is not available for customers on the Standard Edition of Snowflake.

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

Want to get notified when we release new features? 
Subscribe to get notified.