You can use the information_schema.storage_billing view to see daily billing information for storage in all the accounts across all the regions in organization.

SELECT
  *
FROM
  information_schema.storage_billing;

Columns in information_schema.storage_billing

Each row has the following columns.

Column NameData TypeDescription
account_nameTEXTAccount for which the storage is billed
regionTEXTRegion where the data is stored
usage_dateDATEDate for which the usage is reported
consumed_gib_per_monthNUMERICAverage amount of data stored over given date
billed_costNUMERICThe cost for the storage consumed for the given date
is_creditBOOLEANIndicates whether costs were used as credit

Each row represents billing data for a given single day.

Relationship Between consumed_gib_per_month and billed_cost

The billed_cost is calculated using the formula:

billed_cost = consumed_gib_per_month × gib_per_month_regional_price

Where gib_per_month_regional_price is the storage price per GiB in the region where the data is stored, see Data storage pricing.

Example:

Consider the following row from information_schema.storage_billing:

account_nameregionusage_dateconsumed_gib_per_monthbilled_costis_credit
testus-east-12025-06-16770.53303564720.36946218false

Then the customer is charged $20.36946218 for consuming 770.533035647 GiB/Month of data on June 16th in account test.

billed_cost = 770.533035647 × $27.07 / 1024 = $20.36946218

For detailed information about consumed_gib_per_month usage and calculations, see Understanding Storage Billing.