Introducing Snowflake Workload Intelligence

Available for free in the Snowflake Marketplace, Snowflake Workload Intelligence from Keebo gives you the insight you need to manage your Snowflake queries, users, and warehouses.

We at Keebo are pleased to announce the availability of Snowflake Workload Intelligence, which you can start using today in the Snowflake Marketplace. The visibility this application provides is an essential part of optimizing your Snowflake warehouses, whether you want to do it yourself, or alongside our Keebo Warehouse Optimizer, the only fully-automated optimizer on the market today.

What you can do with Snowflake Workload Intelligence

Understand cost drivers

You can see your most expensive queries and even group your queries by their pattern, which we call template, to find those templates that cost the most. This is extremely helpful because in many cases the queries may be identical module constants. For example, a query that calculates the engagement per customer will have a different customer_id for each customer so the frequency or the cost of each unique query may go unnoticed. If you have many customers, being able to automatically cluster those queries together as a single “template” will yield invaluable insight into a pattern that if optimized can result in significant savings. Keebo does this clustering for you!

You can also look at your most expensive users or most expensive warehouses:

With Snowflake Workload Intelligence, you will have the information you need to understand what is driving utilization and thus credit usage. Armed with this information, you can make the adjustments necessary to minimize your credit usage. Knowing the efficiency and utilization of your system, especially with the critical metrics supplied by Snowflake Workload Intelligence, is the first step to optimization.

See the gallery below for more examples of the insights you will get with Snowflake Workload Intelligence.

Advise your data team

The insights you get can assist you in coaching members of your data team regarding efficient queries. Also, the knowledge you gain could help you build new schema and other structures in Snowflake to gain efficiencies for query development and execution.

Stay ahead of the game

If you are like most data people, you don’t like surprises. Running Snowflake Workload Intelligence on a regular basis will help you stay informed about your “heavy hitter” users and queries so you can be ready to adjust as needed.

How to use Snowflake Workload Intelligence

You can be up and running with Snowflake Workload Intelligence in just a few minutes. Get it for free from the Snowflake Marketplace and follow the instructions from there. Once you get started, you will be able to analyze these areas:

Queries

Discover your top queries or query patterns (templates) by warehouse and metrics that are important to you. 

1. Choose your time range
2. Analyze all warehouses together or choose specific warehouses
3. View SELECT queries only, or 20 other types of DDL and DML queries
4. Use cost (credits) as a metric or choose from 7 other metrics, including bytes scanned, compilation/execution times, and spillage

Users

Find your top users and the queries they are running so you can better advise the business on how to efficiently use Snowflake resources.

1. Choose your time range
2. Analyze all warehouses together or choose specific warehouses
3. View all users or select specific users for more detail
4. Use cost (credits) as a metric or choose from 7 other metrics, including bytes scanned, compilation/execution times, and spillage

Warehouses

Take control of your warehouse utilization by analyzing trends and details alike, with these reports available for each warehouse.

• Daily credit usage
• Daily query volume
• Daily execution times
• Daily queuing times
• Query volumes by execution status
• Query volumes by query types
• Top users
• Top queried databases
• Top queried schemas

We hope you enjoy using Snowflake Workload Intelligence and that you get a lot of great insights from it. When you are ready to take what you’ve learned and automate your optimizations, check out our website for more information on our unique, fully-automated warehouse optimizer.

Gallery

Below you’ll find a sampling of the reports you will get from Snowflake Workload Intelligence. Install if for free from the Snowflake Marketplace today and start exploring right away.