Snowflake User Connections Test

To use the snowflake service effectively, the users should be able to swiftly connect to the relevant database and should be able to run the queries. Any delays or connection failures could affect the quality of service and can affect customer experience and in worst case can disrupt business critical service. eG Enterprise helps in identifying any issue related to user connections and helps get to the root cause so that administrators can solve the problem promptly.

This test monitors the connections to the database and collects the statistics related to connection rate and the number of successful and failed connections.

The measures made by this test are as follows:

Target of the test : Snowflake Database Server

Agent deploying the test : A remote agent

Outputs of the test : One set of results for each user present in the Snowflake server 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
Total connections	Indicates the total number of requests for snowflake service.	Number
Total connection rate	Indicates the number of connection requests per second during the last measurement period.	Connections / Seconds
Successful connections	Indicates the number of connection requests which were successful during the last measurement period.	Number	A high value may be indicative of connections not being closed properly by applications, or a bottleneck in the server.
Successful connection rate	Indicates the time taken to connect to the database server.	Connections / Seconds
Failed connections	Indicates the number of failed connection requests during the last measurement period.	Number	A high value can indicate: a configuration problem with the server / clients. some malicious attack on the server
Failed connection rate	Indicates the number of failed connection requests per second during the last measurement period.	Connections / Seconds
Failed percentage	Indicates the percentage of failed connection requests against total connection requests during the last measurement period.	Percentage	The value 0 indicates that no records are fetched from the database.