Viewing Account-level Credit and Storage Usage in the Web Interface

If you have the necessary administrator privileges, you can use the Snowflake web interface to view details about the number of warehouse credits, the number of cloud services credits, and the amount of storage your account uses on a monthly and daily basis.

Note

Only account administrators (i.e. users with the ACCOUNTADMIN role) or a role with the global MONITOR USAGE privilege can access the billing and usage information in the web interface.

Usage information for your account is displayed in either of the following locations:

New Web Interface

Click on Account » Usage.

Note

The Usage page queries the Account Usage views (in the SNOWFLAKE shared database) to retrieve your current usage data. Select a warehouse to provide compute resources for the queries. We recommend choosing an XS (extra small) warehouse for this purpose.

Classic Web Interface

Click on Account Account tab » Billing & Usage

In this Topic:

Setting the Time Zone for Viewing Usage Information (Classic Web Interface Only)

By default, the Billing & Usage tab displays usage information in your local time zone. In contrast, your monthly billing statement, as well as the views/functions in Information Schema and Account Usage, display usage information based on the UTC time zone.

Because all billing charges and usage information is based on the UTC time zone, when viewing the Billing & Usage tab, you might want to use the dropdown provided in the tab to switch to the UTC time zone.

Viewing Credit Usage for Virtual Warehouses

New Web Interface

Click Account » Usage.

Classic Web Interface

Click Account Account tab » Billing & Usage » Credits Billed.

The tab displays credit usage for all warehouses that have been used (and therefore consumed credits) in a given month.

In this display, you can:

  • Select the time period for which you wish to view credit usage.

  • Click the name of a warehouse to view credit usage for the selected warehouse. To de-select a selected warehouse, simply click it again.

  • With no warehouse selected, click a day of the month to view a breakdown of credit usage by warehouse for the selected day.

Viewing Credit Usage for Cloud Services

Viewing credit usage for cloud services is similar to viewing credit usage for virtual warehouses. See Viewing Credit Usage for Virtual Warehouses (in this topic).

Note

When a query consumes cloud services only and does not consume any compute resources from a customer-provisioned virtual warehouse (i.e. credits_used_cloud_services and not credits_used_compute), the credits are captured in the web UI under the warehouse labeled CLOUD_SERVICES_ONLY. This number is likely to be very small as most queries use both a virtual warehouse (compute) and cloud services.

When a query consumes both cloud services and compute resources (i.e. credits_used_cloud_services + credits_used_compute), the credits are captured in the web UI under the customer-provisioned virtual warehouse.

Viewing Storage Usage

New Web Interface

Click Account » Usage.

Classic Web Interface

Click Account Account tab » Billing & Usage » Average Storage Used.

The tab displays the total amount of storage (in bytes) utilized by all your Snowflake databases for your account for the month, including:

  • Storage for data in database tables (including deleted/modified data maintained for Time Travel purposes).

  • Storage for data files in internal stages (used for loading/unloading data in Snowflake).

  • Storage for historical data maintained in Fail-safe.

You can view the average total storage for the month, as well as the daily total storage.

In this display, you can:

  • Select the month (and time zone) for which you wish to view storage usage.

  • Click the filters on the top to display the storage usage by type of storage.

The storage units (MB, GB, TB, etc.) change dynamically depending on the amount of data stored.