Required attributes for the Cloud for Sustainability data model
Some entities/tables in the Microsoft Cloud for Sustainability data models contain required attributes/columns. In some cases, attributes might contain a default value. For example, Organizational unit might show a default value of Unspecified/other. These default values ensure that data remains visible when required for reporting purposes, such as when data quality type is unavailable.
You can download a Microsoft Excel spreadsheet that lists entities and attributes for the Microsoft Cloud for Sustainability data model. For more information, go to Data model spreadsheet downloads.
Be sure to check your Downloads folder for the CSV file after downloading.
Note
The July 2024 release introduced significant flexibility with the Cloud for Sustainability data model by making previously mandatory attributes optional and providing default values in some cases. We relaxed constraints on some required attributes where we determined their impact on data quality and stability to be insubstantial.
Some attributes might become mandatory due to business logic built into other attributes. For example, if you specify Distance, you must also specify Distance unit. Select one of the following links for more specific information about attributes and rules for each data model:
- Required attributes for the shared data model
- Required attributes for the carbon data model
- Required attributes for the water data model
- Required attributes for the waste data model
Article history
| Date | Description |
|---|---|
| July 23, 2024 | Created article to provide more details about the feature first mentioned in Enter data more quickly with fewer required attributes in our release plan documentation. |
Related information
Microsoft Cloud for Sustainability data model overview
