How do I attribute BigQuery cost to a team or pipeline?

-- Spend by job label. Labels must be set by the client that submits the job;
-- unlabeled jobs land in the '(none)' bucket, which is the number to watch.
SELECT
  IFNULL(label.key, '(none)')                               AS label_key,
  IFNULL(label.value, '(none)')                             AS label_value,
  COUNT(*)                                                  AS jobs,
  ROUND(SUM(total_bytes_billed) / POW(1024, 4) * 6.25, 2)   AS est_on_demand_usd,
  ROUND(SUM(total_slot_ms) / 1000 / 3600, 1)                AS slot_hours
FROM `region-us`.INFORMATION_SCHEMA.JOBS_BY_PROJECT
LEFT JOIN UNNEST(labels) AS label
WHERE creation_time >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 30 DAY)
  AND job_type = 'QUERY'
  AND IFNULL(statement_type, '') != 'SCRIPT'
  AND state = 'DONE'
GROUP BY label_key, label_value
ORDER BY est_on_demand_usd DESC;