BigQuery SQL for GCP Billing Reports: Total Costs by Service for a specific Project

gcp_billing_costs_services_by_project.sql

#standardSQL
SELECT 
  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 project.id = '<project_name>'
GROUP BY service.description
ORDER BY total_cost DESC