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, 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 CO 2
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 CO 2 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 CO 2 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 CO 2 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 CO 2 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 CO 2 equivalent. | 105.8
|
carbon_footprint_kgCO2e.scope3
|
Float | Total scope 3 carbon footprint for the account, project, service, location, and month in kg of CO 2 equivalent. | 986.8
|
carbon_offsets_kgCO2e
|
Float | Total carbon offsets for the account, project, service, location, and month in kg of CO 2
equivalent. Currently set to NULL
. |
NULL
|