Diagram
System architecture showing Carbon Footprint data flowing from billing account to dashboard, via Data Transfer Service to a partitioned BigQuery table, then to Looker Studio, Sheets, Looker and billing joins.
Exporting Data for Custom Analysis
Exporting Carbon Footprint data to BigQuery enables custom analysis beyond the built-in dashboard. The BigQuery Data Transfer Service creates a monthly partitioned table called carbon_footprint in a chosen dataset, with exports running on the 15th day of the following month. A backfill can retrieve historical data back to January 2021, and BigQuery storage and query resources used for the export are billed.
Once data is in BigQuery, teams can build custom views with Looker Studio (formerly Data Studio), Google Sheets with pivot tables and charts, or Looker for existing Looker customers. Teams can also join carbon export data with Cloud Billing export data to estimate emissions at the instance level or tag and label level. These granular estimates are approximations because both cost and emissions scale with usage, but they help prioritize high-usage resources for optimization.
Domain 1 of 3
29 practice questions
Practice this DomainLast updated