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

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