Snowflake Network Test

Client data is stored in a database within one of the virtual warehouses hosted on the Snowflake data cloud service. Customers need to have uninterrupted access to their data. Any network issue can at disrupt business customer's critical services and need to be handled and fixed at highest priority. The administrators would like to know in real time if there is any downgrade in the quality of service so that they can take corrective actions in advance.

eG Enterprise uses a JDBC connection to connect to the target database and warehouse in the Snowflake data cloud service. This test monitors the availability and responsiveness of the service and collects statistics related to the traffic in and out of the service.

Target of the test : Snowflake Service

Agent deploying the test : A remote agent

Outputs of the test : One set of results for each database present in the warehouse 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
Availability	Indicates whether the network connection is available or not.	Percentage	The availability is 100% when the server does respond to a request and 0% when it is not. Availability problems may be caused by a misconfiguration / malfunctioning of the database server, or if the server has not been started. Besides the above, this measure will report that the server is unavailable even if a connection to the database instance is unavailable, or if a query to the database fails. In this case, you can check the values of the SnowflakeConAvailable and SnowflakeQryAvailable measures to know what is exactly causing the database instance to not respond to requests - is it owing to a connection unavailability? or is it due to a query failure? The detailed diagnosis of this measure shows the exact error message received while connecting to database in Details of connection availability field.
Response time	Indicates the time taken by the database to respond to a user query. This includes both connection time and query execution time.	Seconds	A sudden increase in response time is indicative of a bottleneck with the database server.
Database connection availability	Indicates whether the database connection is available or not.	Percentage	If this measure reports the value 100 , it indicates that the database connection is available. The value 0 on the other hand indicates that the database connection is unavailable. A connection to the database may be unavailable if the database is down or if the database is listening on a port other than the one configured for it in the eG manager or owing to a poor network link. If the Availability measure reports the value 0, then, you can check the value of this measure to determine whether or not it is due to the unavailability of a connection to the server.
Connection time to database	Indicates the time taken to connect to the database server.	Seconds	A dramatic increase in this value may be because the service has reached its connection handling capacity.
Query processor availability	Indicates whether the database query is executed successfully or not.	Percentage	If this measure reports the value 100, it indicates that the query was executed successfully. The value 0 on the other hand indicates that the query failed. If the Availability measure reports the value 0, check the value of this measure to figure out whether the failed query is the reason why that measure reported server unavailability.
Query execution time	Indicates the time taken to execute a database query during the last measurement period.	Seconds	A jump in value as compared to the last measurement could indicate a bottleneck in processing.
Records fetched	Indicates the number of records fetched from the database during the last measurement period.	Number	The value 0 indicates that no records are fetched from the database.