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	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
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.