Extract billing from BigQuery

gistfile1.txt

SELECT
  project.id as ID,
  invoice.month as Month,
  service.description as ServiceDescription,
  service.id as ServiceID,
  sku.description as SKUDescription,
  sku.id as SKUID,
  location.location as Region,
  SUM(usage.amount_in_pricing_units) as UsageAmount,
  usage.pricing_unit as UsageUnit,
  SUM(cost) as ActualCost, #optional
  FROM `<project>.<dataset>.gcp_billing_export_v1_<UUID>`    # Replace project, table, and UUID.
WHERE invoice.month = "202304"   # Modify this clause for the period of time.
AND cost_type = "regular"   # This will filter out private pricing, credits, and discounts. 
GROUP BY ID,
         Month,
         ServiceDescription, 
         ServiceID, 
         SKUDescription, 
         SKUID, 
         Region, 
         UsageUnit
ORDER BY ServiceID ASC, SKUID ASC
;