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

Specify the name of the user who has any of the following privileges to the specified.

Password

The password of the specified USER.

Confirm Password

Confirm the password by retyping it here.

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