Monitor Center

About

This app is designed to monitor Snowflake activities in real-time. With flexible configurations, you can:

​

• Prevent runaway queries from consuming unexpected credits.

• Get notified when the warehouse is overloaded or when a critical job exceeds a certain duration.

• Choose to automatically cancel a running query if specific conditions are met.

​

If you would like to receive automatic email notifications, please follow the instructions below to set up email notifications.

​

Set Up

• On the Monitor Page, change the monitor frequency to your desired value (default: every 1 minute).

• Click on the "Turn On" button to start monitoring.

• Stop the monitoring using "Turn Off" button. 

​

The monitor runs in the background at the specified frequency, so you do not need to keep the app running for the monitoring to work.

​​

Configuration​

Configuration Page is where you define various conditions you want to monitor.  For example: 

​

Example 1:  Long-running query over 5 minutes:

start_time < dateadd(minute, -5, current_timestamp()) 

​​

Example 2:  Queued query due to warehouse overload: 

QUEUED_OVERLOAD_TIME > 60000 

​​

Example 3: Excessive Credit Usage:

credit_used(warehouse_size,execution_time) > 1 

​​

Example 4: Critical Job still running after 2am:

query_tag = 'FINISH BY 2am' and run_hour()>2

​​

You can combine multiple conditions to define your monitor criteria.  For a complete set of these conditions, please refer to snowflake documentation.

​

​​Setup Email Alert

Currently, Native App does NOT support Email Notification. Please follow details steps from Snowflake Native App to set it up outside Native App. You should be able to receive an email alert similar to below:

​​​​

​

​

​

​​​​​​​​​​​​​

 

Support

If you have questions, encounter problems, or would like more advanced features, feel free to contact us at contact@maxmycloud.com with the subject line: "monitor support".  You can also visit us at: maxmycloud.com