Create empty ESG data model schema tables
The environmental, social, and governance (ESG) data model provides the centralized schema in Sustainability data solutions in Microsoft Fabric to unify your ESG data from disparate sources. The schema is built specifically for ESG analytical and reporting use cases and is comprehensive and extensible with over 500 tables categorized into various business areas.
You can explore the schema in your Sustainability data solutions in Fabric workspace using the ESGScehma.json file that is located under the Config folder in the lakehouse named ConfigAndDemoData_LH.
The ESGSchema.json file provides the details of the column names, primary keys, and foreign key relationships for each table in the ESG data model.
When you run the GenerateESGTables_INTB notebook from your Sustainability data solutions in Fabric workspace, you can create empty ESG data model tables in the lakehouse ProcessedESGData_LH.
You can configure the GenerateESGTables_INTB notebook to create tables for a specific business area by modifying the SELECTED_BUSINESS_AREA parameter to one of the following:
- GHG Emissions
- Waste Sustainability
- Water Sustainability
- Environmental Social and Governance
- Circularity
- Business Management
- Party
