It was pointed out that there is a query label we can associate with bigquery queries to simplify cost attribution:

SET @@query_label = "jupierce:expensive";

With it we can use the dashboard to analysis where cost if from. Justine started with this https://lookerstudio.google.com/reporting/9af4ffb3-f239-4dd8-8ffb-8ee5c278259d/page/Kg62D

We will need to go through our queries (go, dashboards etc) to add query_label.