BigQuery SQL for GCP Billing Reports: Total BigQuery Costs over the last year

gcp_billing_costs_total_bigquery_costs.sql

#standardSQL
SELECT 
  project.id
  , service.description
  , ROUND(SUM(cost),2) AS total_cost
FROM `<project_id>.<dataset_id>.gcp_billing_export_v1_XXXXXX_XXXXXX_XXXXXX`
WHERE _PARTITIONTIME BETWEEN TIMESTAMP(DATE_SUB(CURRENT_DATE(), INTERVAL 365 DAY)) AND TIMESTAMP(CURRENT_DATE())
  AND STARTS_WITH(service.description, 'BigQuery')
GROUP BY project.id, service.description
ORDER BY total_cost DESC