BigQuery Storage Cost didn't match with Billing Report

Hi! I'm trying to get storage cost in BQ with following query:

with
    data as (
        select
            sum(billable_active_logical_usage) as billable_active_logical_mb,
            sum(billable_long_term_logical_usage) as billable_long_term_logical_mb
        from `region-EU`.`INFORMATION_SCHEMA`.`TABLE_STORAGE_USAGE_TIMELINE`
        where date_trunc(usage_date, month) = '2023-12-01'
    ),
    data2 as (
        select
            *,
            billable_active_logical_mb / 1024 as billable_active_logical_gb,
            billable_long_term_logical_mb / 1204 as billable_long_term_logical_gb
        from data
    ),
    data3 as (
        select
            *,
            billable_active_logical_gb * 0.02  as billable_active_logical_usd,
            billable_long_term_logical_gb * 0.01  as billable_long_term_logical_usd
        from data2
    )

select *
from data3

But it gives me weird results with thousands of USD in last CTE. Spend a lot of time on figuring out how to get values close to Billing Report but no luck. Any thoughts on how to do it correctly?

0 0 44
0 REPLIES 0