Analyze read/write workloads for your Snowflake tables
- Date
- Niall WoodwardCo-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.
Write workloads are those that perform some DML operations against the table (i.e. an insert, update, delete, etc).
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.
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.
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.