Snowflake Warehouse Availability Test

The business capability supported by Snowflake for any customer is designed around virtual warehouses. The performance and availability of each of the warehouse is critical to business, so it is absolutely important for administrators to keep an eye on warehouse related statistics like running statements, queued statements and warehouse compute capacity available. These metrics help them predict the load on warehouse and take any measures to avoid warehouse failure. This test monitors the user account and collects statistics related to warehouse availability status, status of query statements etc. These metrics provide valuable insights to the administrators about the current working condition of warehouse.

Target of the test : Snowflake Database server

Agent deploying the test : A remote agent

Outputs of the test : One set of results for each warehouse in the Snowflake service account being monitored.

Configurable parameters for the test

Parameter	Description
Test period	How often should the test be executed.
Host	The IP address of the Snowflake.
Port	The port number through which the snowflake database server communicates. The default port is 443.
Warehouse Name	In this text box, enter the name of a virtual warehouse that needs to be monitored.
Database Name	In this text box, enter the name of a default database that will connect the snowflake server.
User Name, Password and Confirm Password	In order to monitor a Snowflake account which hosts the Snowflake instances to be monitored, you need a special user with privileges of an account administrator who can access the Snowflake instances and execute the required commands to pull out the performance metrics. To know how to create such a user and assign a role, refer to Pre-requisites for Monitoring Snowflake. Specify credentials of such user in the User Name and Password text boxes. Confirm the password by retyping it in the Confirm Password text box.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Status	Indicates the status of the warehouse whether it is started, running, or inactive.	Boolean
Running statements	Indicates the total number of running statement during the last measurement period.	Number	A very high number of running statements can be concerning as it is holding on to compute resources.
Queuing statements	Indicates the total number of queuing statement during the last measurement period.	Number	A very high number of queueing statements can be concerning as the queuing time will increase.
Available percentage	Indicates the percentage of the warehouse compute resources that are provisioned and are available.	Percentage	Less than 100 percent is a cause for concern.
Provisioning percentage	Indicates the percentage of the warehouse compute resources that are in the process of provisioning.	Percentage
Quiescing percentage	Indicates the percentage of the warehouse compute resources that are executing SQL statements but will be shut down once the queries are complete.	Percentage