This Retool app extends Snowflake's Resource Optimization: Setup & Configuration Quickstart Guide. If you use Snowflake, it will help you better monitor and manage your credit consumption, and avoid spending more than you need to.
This Retool app makes it easy to put the Quickstart Guide into practice, by enabling you to take action from right within an easy-to-use UI. Without having to remember or type any commands, you can set auto-suspend or auto-resume for your warehouses, suspend or drop idle warehouses, disable or drop idle users, etc.
The Snowflake Resource Optimization: Setup & Configuration app lets you do the following things with the click of a button:
- Identify warehouses without auto-resume enabled and enable it
- Identify warehouses without auto-suspend enabled and enable it for your chosen duration
- Identify warehouses with long suspension and modify the auto-suspend setting
- Identify warehouses without resource monitors and assign them where needed
- Identify idle warehouses and suspend or drop them
- Review warehouses used by multiple roles and investigate relevant query metrics
- Identify idle users and disable or drop them
- Identify users who have never logged in and disable or drop them
- Identify idle roles and drop them
- Identify failed tasks and show query history or drop them
- Identify long running tasks and show query history or drop them
- Review account, warehouse, or user statement timeouts and modify them
- Identify stale table streams to potentially recreate
 |
 |
 |
 |
This tool will enable users to make irreversible changes, such as dropping warehouses, users, roles, or tasks. It is set up to leverage the ACCOUNTADMIN role, and as such should only be used by Snowflake administrators who are trusted to make such changes.
The Snowflake Resource Optimization: Setup & Configuration app depends on the following backend services:
- Snowflake
See the detailed setup guides in the Setup Guides folder.
As an overview, these guides will take you through:
- Setting up Snowflake.
- Setting up your Snowflake database as a Resource in Retool.
- Downloading and configuring the Retool app file.
Please find some relevant considerations below:
- In Snowflake's Resource Optimization: Setup & Configuration Quickstart Guide, the Idle Users, Users Never Logged In, and Idle Roles queries leverage the ACCOUNT_USAGE schema. The Retool app, however, uses Snowflake DDL (e.g. SHOW USERS) to avoid the latency associated with the ACCOUNT_USAGE schema. This means that you are able to review and update users and roles as soon as they are created in Snowflake. It also means that these queries do not show deleted users or roles.
- The Failed Tasks and Long Running Tasks queries can take a long time to run. Feel free to modify them using Snowflake's recommendations as needed.
Please open a Github Issue on this repo, and let us know about your interest in contributing! We encourage you to reach out before you get started building to get early feedback.