Snowflake Credit Usage by Warehouse Test

The virtual warehouses on Snowflake consume credit only when they are active. The cost charged to the customer by Snowflake is dependent upon the size of the database and the amount of time the warehouse run. In case the warehouse size is more than required or a warehouse is running despite the work being done, it may consume extra charges. Administrators always need a way to be informed if there are any unnecessary charges are consumed.

eG Enterprise monitors credit usage and can provide you with important insights into how the credits are being consumed across the organization. Using these insights administrators can decide if database size or running duration can be optimized to save cost.

This test monitors each warehouse for credit usage and collects statistics related to the trend of credit usage and rate of credit consumption. Looking at these metrics administrators can identify the root cause of any unexpected surge in credit consumption, this, in turn, can help them re-architecture the warehouse design by shutting down unused warehouses and re-directing the queries on more used ones.

Target of the test : Snowflake Database Server

Agent deploying the test : A remote agent

Outputs of the test : One set of results for each warehouse present in 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	Interpretation
Credits used by warehouse	Indicates the number of credits used by each warehouse as measured during the last measurement period.	Number	If you notice a surge in credits used, you may want to take a closer look at query throughput over the last few measurements. For example, if your warehouse is consuming credit while executing only one query in an hour, you may want to change the configuration so it consumes credit only when executing query.
Credits used by cloud service	Indicates the number of credits used by cloud service as measured during the last measurement period.	Number
Credits usage	Indicates the total credit usage including both warehouse and cloud service.	Number
Credits used rate	Indicates the rate at which credits are consumed during the last measurement period.	Credits / hour