# Microsoft Fabric Lakehouse Documentation

> **Note:** This documentation is mandatory for all production lakehouses.
> Irrelevant chapters may be left empty but must not be removed.
> Automatically populated fields come from the Microsoft Fabric Service; fields
> marked _"To be completed"_ must be filled in from a business perspective.

---

## 1. Metadata

| Field | Value |
|-----|------|
| Lakehouse Name | {{LH_Name}} |
| Description | {{LH_Beschreibung}} |
| Lakehouse ID | {{LH_ID}} |
| Web URL | {{LH_WebUrl}} |
| Default Schema | {{LH_DefaultSchema}} |
| SQL Endpoint (connection) | {{LH_SqlConnection}} |
| SQL Endpoint ID | {{LH_SqlEndpointId}} |
| SQL Endpoint Status | {{LH_SqlStatus}} |
| Created / configured by | {{LH_ConfiguredBy}} |
| Last modified | {{LH_ModifiedTime}} |
| Business Unit | {{LH_Fachbereich}} |
| Domain | {{LH_Konzerndomaene}} |
| Current Version | 1.0 |
| Status | Production |
| Last Updated | {{LH_ExportDatum}} |

---

## 2. Contacts & Responsibilities

| Role | Name / Team | Contact |
|-----|-------------|--------|
| Business Owner | {{KONTAKT_BusinessOwner}} | {{KONTAKT_BusinessOwnerMail}} |
| Technical Owner | {{KONTAKT_TechOwner}} | {{KONTAKT_TechOwnerMail}} |
| Data Steward | {{KONTAKT_DataSteward}} | {{KONTAKT_DataStewardMail}} |
| Operations / Support | {{KONTAKT_Betrieb}} | {{KONTAKT_BetriebMail}} |

---

## 3. Business Objective & Context

### 3.1 Objective
{{LH_Zielsetzung}}

### 3.2 Business Use Case
{{LH_Anwendungsfall}}

### 3.3 Downstream Consumers (Semantic Models / Reports / Notebooks)
{{LH_Konsumenten}}

---

## 4. Structure & Layout

### 4.1 Table Overview

{{LH_TabellenTabelle}}

### 4.2 Storage & Endpoints

{{LH_EndpunktTabelle}}

---

## 5. Data Sources & Loading

### 5.1 Data Sources / Upstream Processes

{{LH_DatenquellenTabelle}}

### 5.2 Detailed Description per Data Source
{{LH_DatenquellenDetail}}

---

## 6. Content & Usage

{{LH_ServiceHinweis}}

### 6.1 Tables in Detail

{{LH_TabellenDetail}}

### 6.2 Access via the SQL Analytics Endpoint
{{LH_EndpointHinweis}}

### 6.3 Parameters & Configuration
{{LH_ParameterHinweis}}

### 6.4 Data Quality

- NULL / missing value handling: {{LH_NullHandling}}
- Data validation rules: {{LH_Validierungsregeln}}
- Retention / historization: {{LH_Aufbewahrung}}

### 6.5 Performance Notes

- Partitioning / optimization (OPTIMIZE, V-Order): {{LH_Optimierung}}
- Known performance bottlenecks: {{LH_PerformanceHinweise}}
- Additional measures: {{LH_Optimierungen}}

---

## 7. Operations & Maintenance

### 7.1 Loading & Orchestration

{{LH_Beladung}}

### 7.2 Monitoring & Error Handling
{{LH_Monitoring}}

### 7.3 Known Issues / Technical Debt
{{LH_BekannteProbleme}}

---

## 8. Security & Permissions

### 8.1 Access & Sharing
{{LH_Zugriffe}}

### 8.2 Sensitivity Labels
{{LH_Labels}}

### 8.3 Risks & Limitations
{{LH_Risiken}}

---

## 9. Versioning & Change History

### 9.1 Repository / Storage
{{LH_Repository}}

### 9.2 Change Log

| Version | Date | Change | Type (business/technical) | Author |
|-------|-------|---------|--------------------------|-------|
| 1.0 | {{LH_ExportDatum}} | Automatic initial documentation | technical | Auto-Documentation |

---

## 10. Approval & Review

| Role | Name | Date | Comment |
|-----|------|-------|----------|
| Business | {{REVIEW_FachName}} | {{REVIEW_FachDatum}} | {{REVIEW_FachKommentar}} |
| Technical | {{REVIEW_TechName}} | {{REVIEW_TechDatum}} | {{REVIEW_TechKommentar}} |

---

## 11. Appendices & References
- Parent workspace documentation
- Architecture diagrams
- Regulatory evidence (separate)
