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.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_footprint_total_kgCO2e.after_offsets |
Float | [DEPRECATED] 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. Set to NULL because this field is deprecated due to Google's Strategic shift from conventional carbon offsets to a direct focus on carbon removal technologies. |
NULL |
carbon_offsets_kgCO2e |
Float | [DEPRECATED] Total carbon offsets for the account, project, service, location, and month in kg of CO2 equivalent. Set to NULL because this field is deprecated due to Google's Strategic shift from conventional carbon offsets to a direct focus on carbon removal technologies. |
NULL |