Snowflake Automatic Clustering Test

Automatic Clustering is the Snowflake service that seamlessly and continually manages all reclustering, as needed, of clustered tables. Automatic clustering consumes credits, so if automatic clustering is enabled or resumed on a table and it has been a while since the table was clustered, the reclustering activity will start and corresponding credits will be consumed. Similarly, defining a clustering key on existing table or changing the clustering key on clustered table will trigger reclustering and credit charges.

Since the credit charges are consumed automatically, it is important for users and administrators to track the reclustering activity, prevent any unexpected charges and ensure that only intended actions are resulting in credit consumption.

This test monitors the Snowflake cloud and collects the credit usage-related metrics for the Automatic Clustering service in real time, using which administrators can make informed decisions on planning the reclustering activity and avoid any unintended actions leading to credit consumption.

Target of the test : Snowflake Database Server

Agent deploying the test : A remote agent

Outputs of the test : One set of results for each 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.
DD Count	In the DD Count text box, specify the number of expensive tables which the detailed analysis is to be reported in the DETAILED DIAGNOSIS section. By default, the value specified in this text box is 5. This indicates that detailed analysis of the top 5 expensive tables executing on the SAP HANA database server will alone be listed in the DETAILED DIAGNOSIS section.
Detailed Diagnosis	To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option. The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled: The eG manager license should allow the detailed diagnosis capability Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.

Measurements made by the test
Measurement	Description	Measurement Unit
Total credits used	Indicates the total credit used by automatic clustering service as measured in the last measurement period.	Number
Average credits used	Indicates the average credits used by automatic clustering service over a definite number of measurements.	Number
Total data reclustered	Indicates the total data re-clustered by automatic clustering service.	MB
Average data reclustered	Indicates the average data re-clustered by automatic clustering service over measurement periods.	MB
Total rows reclustered	Indicates the total rows re-clustered by automatic clustering service.	Number
Average rows reclustered	Indicates the average rows re-clustered by clustering service over the definite number of measurement periods.	Number