Carbon Footprint export data schema
After configuring an export, a BigQuery table with the following schema is created:
| Field | Type | Description | Example |
|---|---|---|---|
usage_month |
Date | Month during which this usage occurred | 2021-10-01 |
billing_account_id |
String | The Cloud Billing account ID used for the carbon footprint export | 007GD7-15C0E6-BDE6B3 |
project.id |
String | Identifier of the Google Cloud project the carbon footprint is from | my-project |
project.number |
String | Number of the Google Cloud project the carbon footprint is from | 802583874831 |
service.description |
String | Readable name for the Google Cloud service the carbon footprint is from | Cloud Run |
service.id |
String | Identifier of the Google Cloud service the carbon footprint is from | F17B-412E-CB64 |
location.location |
String | Location of the carbon footprint at the level of a country, region, or zone | us-central1-a |
location.region |
String | Cloud region for the carbon footprint. | us-central1 |
carbon_model_version |
Integer | Version of carbon model that produced this output. This value is updated whenever the model is changed | 1 |
carbon_footprint_total_kgCO2e.after_offsets |
Float | Total carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. Equivalent to scope 1 + scope 2 market-based + scope 3 + carbon offsets. Currently set to NULL |
NULL |
carbon_footprint_total_kgCO2e.market_based |
Float | Total carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. Equivalent to scope 1 + scope 2 market-based + scope 3. | 588.8 |
carbon_footprint_total_kgCO2e.location_based |
Float | Total carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. Equivalent to scope 1 + scope 2 location-based + scope 3 | 1587.3 |
carbon_footprint_kgCO2e.scope1 |
Float | Total scope 1 carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent | 10 |
carbon_footprint_kgCO2e.scope2.location_based |
Float | Total scope 2 location-based carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent | 400 |
carbon_footprint_kgCO2e.scope2.market_based |
Float | Total scope 2 market-based carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. | 105.8 |
carbon_footprint_kgCO2e.scope3 |
Float | Total scope 3 carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent | 986.8 |
carbon_offsets_kgCO2e |
Float | Total carbon offsets for the account, project, service, location, and month in kg of CO2 equivalent. Currently set to NULL |
NULL |