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 | Cloud Billing account ID used for the carbon footprint export. | 007GD7-15C0E6-BDE6B3 |
project.id |
String | Google Cloud project identifier associated with the carbon footprint data. If data isn't associated with a project or project was deleted, then the project.id field is NULL. |
my-project |
project.number |
String | Google Cloud project number associated with the carbon footprint data. If data isn't associated with a project, then the project.number field is an empty string. |
802583874831 |
service.description |
String | Readable name for the Google Cloud service associated with the carbon footprint data. | Cloud Run |
service.id |
String | Identifier of the Google Cloud service associated with the carbon footprint data. | 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 |