About

Introduction

SELECT's Health Check native app provides high level account usage insights, along with an estimate of the automated savings that the full SELECT app can achieve.

Installation

Install the app from the native app marketplace listing. The app is available for free to all Snowflake accounts running in AWS. Native apps are not yet in public availability in other cloud providers.

Once installed, the app requires some permissions to run metadata queries in your account. From an accountadmin role, the permissions can be granted by running the below commands.

1grant manage warehouses on account to application health_check;
2grant imported privileges on database snowflake to application health_check;

Please note that if you rename the share from health_check to something else, you will need to replace the health_check text in the SQL above with the name you used.

Available Procedures

Before running the procedures, follow the setup instructions above.

health_check.core.healthcheck()

This stored procedure provides a high-level account health report. The stored procedure highlights:

Unused warehouses
The top 5 warehouses by credit usage from the last 24 hours
The top 5 query patterns from the last 24 hours

A query pattern is a grouping of queries by similar structure, ignoring literals and other typically changeable elements.

To run this procedure:

1call health_check.core.healthcheck();

Example response:

1SELECT Healthcheck Results
2There are 20 warehouses in the account.
3The following warehouses have not been used in 60 days and can likely be dropped:
4DBT_CLOUD
5LOOKER
6BI
7TRANSFORM_XSMALL
8The top 5 most expensive warehouses in the last 24 hours were:
9- APP_BACKEND_SMALL with 36.005 credits used (77.00% of total).
10- APP_BACKEND_DBT_MEDIUM with 6.664 credits used (14.00% of total).
11- APP_BACKEND with 2.653 credits used (6.00% of total).
12- APP_BACKEND_LARGE with 0.842 credits used (2.00% of total).
13- APP_BACKEND_SMALL with 0.625 credits used (1.00% of total).
14The top 5 query patterns in the last 24 hours were:
151. Example query ID: 01af1c27-0000-33b3-0000-3de90338e232

health_check.core.savings_estimate(date)

This stored procedure provides an annualized estimate for the automated savings that the full SELECT app would have provided on a given date.