Snowflake Warehouse Workload Test

The primary goal of data warehousing is to be able to perform fast analytics and reporting. To achieve this goal it is important that workload on the warehouse is managed effectively and any indication of performance degradation due to excessive load can be handled in advance.

This test monitors each warehouse for query run times and queuing times and provides valuable statistics to administrators to understand the load on the 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
Average running	Indicated the average number of queries executed during a measurement period.	Number
Average queued load	Indicates the average number of queries queued because the warehouse was overloaded.	Number	Indicates the high workload on the warehouse.
Average queued provisioning	Indicates the average number of queries queued because the warehouse was being provisioned.	Number	A high value could indicate the slow provisioning pipeline.
Average blocked	Indicates the average number of queries blocked by a transaction lock.	Number	A high value could indicate too many transaction locks occurring.