scripts/billing/sql/previous_day_costs_by_project.sql

/*
Query returns the previous day's total costs by project name
*/

SELECT
  project.name AS project_name,
  sum(cost) AS costs 
FROM `bqutil.billing.billing_dashboard_export` 
WHERE DATE(export_time) = DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
GROUP BY project_name
ORDER BY costs DESC