Ava-Watch Real Time Query Monitor

This app is to prevent runaway queries consuming unexpected credits in your system. Once you set up the app first time, you will receive an alert if there are queries running longer than the threshold you defined. You can then decide which actions to take, either leave the query running or kill the query if it is indeed problematic one.

Most users prefer to receive alerts in email. Currently, snowflake Native App does not support email. Follow instructions from readme file to set up email outside Native App, those steps are simple and straightforward.

Cost to Run the App:

Warehouse credit will be consumed when the App start monitoring your snowflake just like when running any queries. The amount of credits consumed depends on how frequent you like the monitor to run. By default, the App wakes up every 10 mins to check if any long running queries exceeding the threshold you defined in the Main page, daily credit consumption will be 2.4 credits/day. If you change the configuration to run more frequently (say, every 1 min), then credit consumption will be increased to 24 credits/day. Please adjust frequency accordingly.

Tips: Please use the Xsmall warehouse and set warehouse auto suspend to 60 seconds to minimize the cost. This app is lightweight, each monitor run will last only a few seconds.
Tips: To minimize the cost of running this app, you can share the same warehouse with other workloads you may already have.