Snowflake Credit Usage by Services Test

Features that rely on Snowflake-managed compute resources appear on your bill as separate line items. Charges for these features are calculated based on the total usage of the resources (including cloud service usage) measured in compute-hours credit usage. One compute-hour is comparable to the computing resources utilized when running an X-Small virtual warehouse for an hour.

Credit charges are consumed by Snowflake services automatically and it may happen that at any point of time one of the services is performing a task which is not required, or has been configured to use much more resources than necessary. If the service activity is not monitored, these services can end up consuming much more credits than required and administrators will come to know of the unexpected charges only when they look at the bill. To avoid this situation eG the credit usage needs to be monitored in real time so that administrators can take immediate action if they see unexpected charges.

This test monitors the virtual warehouses under user account and collects metrics related to credits use by each service in real time and provides metrics like credits used by warehouse and cloud service, billing and billing rate, looking at which administrators can make a call if credit consumption is as per expectations.

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

Indicates the total number of credits used by warehouse services.

Number

 

Credits used by cloud service

Indicates the total number of credits used by cloud services.

Number

 

Credits usage

Indicates the total number of credits used so far.

Number

 

Credits billed

Indicates the credits billed to the customer.

Number

Calculated as the sum of

Credits used and Credit cloud adjustments.

Credits billed rate

Indicates the credits billing rate during the last measurement period.

Credits / hour