BLOCK_STORAGE_HISTORY view (Account Usage): New columns ADDITIONAL_IOPS and ADDITIONAL_THROUGHPUT (Preview)

Attention

This behavior change is in the 2025_02 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the Account Usage BLOCK_STORAGE_HISTORY view includes the following new columns:

Column name

Data type

Description

ADDITIONAL_IOPS

NUMBER

Average number of additional IOPS used on the given date.

ADDITIONAL_THROUGHPUT

NUMBER

Average amount of additional throughput (MiB per second) used on the given date.

Additional IOPS and throughput refer to block configuration values exceeding the default settings (see Specifying block storage in service specification). For example, on AWS, the block configuration default IOPS is 3,000, and the default throughput is 125 MiB/second. If you configure an AWS block device with 4,000 IOPS and 225 MiB/second throughput, the additional IOPS would be 1,000 (4,000 - 3,000), and the additional throughput would be 100 MiB/second (225 - 125).

The following three examples illustrate how you can get this information from the BLOCK_STORAGE_HISTORY view. Suppose that your account is set up with the following:

  • Your account provisioned a 10 GB block volume (as part of a service) with 1000 additional IOPS and 100 MiB/second additional throughput for 6 hours on 2025-02-01 for compute pool pool_1. If you query the view, you can get the following information from the additional_iops and additional_throughput columns:

    • Using 10 GB for 6 hours equals 2.5 GB per day (10 GB x 6/24 hours = 2.5 GB = 2684354560 bytes per day).

    • Using 1000 additional IOPS for 6 hours equals 250 IOPS per day (1000 IOPS * 6/24 hours = 250 IOPS per day).

    • Using 100 additional MiB/second for 6 hours equals average 25 MiB/second per day (100 MiB * 6/24 hours = 25 MiB per day).

  • Your account is provisioned a 10 GB block volume (as part of a service) with 1 additional IOPS and 1 MiB/s additional throughput for 12 hours on 2025-02-01 for compute pool POOL_2.

    • Using 10 GB for 12 hours equals 5 GB per day (10 GB * 12/24 hours = 5 GB = 5368709120 bytes per day).

    • 1 additional IOPS used for 12 hours equals 0.5 IOPS per day (1 IOPS * 12/24 =hours 0.5 IOPS per day).

    • 1 additional MiB/second throughput MiB/s used for 12 hours equals 0.5 MiB/second per day (1 MiB * 12/24 hours = 0.5 MiB per day)

  • You use a 20 GB snapshot for 24 hours on 2025-02-01. Using 20 GB for 24 hours is equivalent to 20 GB (21474836480 bytes) per day.

When you query the view:

SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.BLOCK_STORAGE_HISTORY;
Copy

The bytes, additional_iops, and additional_throughput columns in the query output provide this information:

+-------------------------------+--------------------+-------------------------+----------------+-----------------------+-----------------------------+
| USAGE_DATE                    | STORAGE_TYPE       | COMPUTE_POOL_NAME       |       BYTES    |       ADDITIONAL_IOPS |       ADDITIONAL_THROUGHPUT |
|-------------------------------+--------------------+-------------------------+----------------|-----------------------|-----------------------------|
| 2025-02-01 00:00:00.000 -0700 | BLOCK_STORAGE      | POOL_1                  | 2,684,354,560  | 250.000000000         | 25.000000000                |
| 2025-02-01 00:00:00.000 -0700 | BLOCK_STORAGE      | POOL_2                  | 5,368,709,120  | 0.50000000            | 0.500000000                 |
| 2025-02-01 00:00:00.000 -0700 | SNAPSHOT           | NULL                    | 21,474,836,480 | 0.000000000           | 0.000000000                 |
+-------------------------------+--------------------+-------------------------+----------------+-----------------------+-----------------------------+

Ref: 1921

Language: English