Bigquery Reservation API

Hello!

I need help with a problem calculating BQ costs. My query pulls slot information from region-us.INFORMATION-SCHEMA.JOBS_BY_ORGANIZATION and JOBS_BY_PROJECT.

I'm calculating (avg_slots * amount charged).

(Note: there are discounts applied by the provider to the client, so it's a lower value than the one in the documentation).

Anyway, we use Enterprise Edition and there are two types of charges: Enterprise Edition 1 year and Enterprise Edition On Demand (which I believe would be pay as you go, mentioned in the Enterprise Edition table in the documentation).

The issue is that these types have different charge values, so I would like to know how to identify what is Enterprise Edition 1 year and what is Enterprise Edition pay as you go/On demand so that I can correctly calculate BQ cost values.

These tables don't show SKU, so I don't know how to make this separation.

enter image description here

I tried to look for a field that brought this information in these tables, but I only found the "edition" field but it only says "ENTERPRISE".