Health Check Native App

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.

grant manage warehouses on account to application health_check;
grant 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:

1. Unused warehouses
2. The top 5 warehouses by credit usage from the last 24 hours
3. 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:

call health_check.core.healthcheck();

Example response:

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.

To run this procedure:

call health_check.core.savings_estimate('2023-08-01'); -- update the date as required for an up-to-date estimate

Example response: