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



Test period

How often should the test be executed.


The IP address of the Snowflake.


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.


Specify the name of the user who has any of the following privileges to the specified.


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 Unit


Total credits used

Indicates the total credit used by automatic clustering service as measured in the last measurement period.



Average credits used

Indicates the average credits used by automatic clustering service over a definite number of measurements.



Total data reclustered

Indicates the total data re-clustered by automatic clustering service.



Average data reclustered

Indicates the average data re-clustered by automatic clustering service over measurement periods.



Total rows reclustered

Indicates the total rows re-clustered by automatic clustering service.



Average rows reclustered

Indicates the average rows re-clustered by clustering service over the definite number of measurement periods.