Hello GCP community,
I am using BigQuery on-demand pricing, and I want to find details about jobs and their costs, so the INFORMATION_SCHEMA.jobs table looked perfect for such need.
However, after working on it for DAYS trying to get the perfect query, and checking again with GCP support I still can't find why my query is not showing the the same total_bytes_billed as the usage that is being shown in the billing report.
We use region-EU so I am comparing specifically the SKU with id: 1DF5-1F98-1DD1. "Tebibytes used" that is being shown in the billing report for that specific SKU is 40% higher than the "tebibytes used" from the INFORMATION_SCHEMA.jobs table.
I know this has been raised here before but I checked the replies and it still doesn't give a clear answer. I am comparing to the correct SKU, so it's not about billing page counting for more BigQuery features because I am selecting the correct one. I am also making sure to compare old dates so that I'm sure the billing report is synced. And finally rounding differences cannot lead to a 40% difference.
I want to know what I'm missing from my query in order to match the number shown by the Analysis (compute) SKU which is 1DF5-1F98-1DD1.
My query for reference:
SELECT
SUM(ROUND((total_bytes_billed / 1e12) * 6.25, 4)) AS cost_usd,
SUM(ROUND((total_bytes_billed / 1e12) * 5.6334375, 4)) AS cost_chf,
sum((total_bytes_billed / 1e12)) as total_usage_tebibytes
FROM
`region-EU`.INFORMATION_SCHEMA.JOBS
WHERE
job_type = 'QUERY'
AND date(creation_time) = '2025-03-11'
Thanks in advance!
LinkedIn
Twitter
