# Microsoft Fabric KQL Database Documentation

> **Note:** This documentation is mandatory for all production KQL databases.
> Irrelevant chapters may remain empty but must not be removed. Automatically
> filled fields come from the Microsoft Fabric service; fields marked
> _"To be completed"_ must be completed manually.

---

## 1. Metadata

| Field | Value |
|-----|------|
| KQL database name | {{KH_Name}} |
| Description | {{KH_Beschreibung}} |
| KQL database ID | {{KH_ID}} |
| Web URL | {{KH_WebUrl}} |
| Database type | {{KH_DatabaseType}} |
| Parent eventhouse | {{KH_ParentEventhouse}} |
| Query endpoint | {{KH_QueryUri}} |
| Ingestion endpoint | {{KH_IngestionUri}} |
| Created / configured by | {{KH_ConfiguredBy}} |
| Last modified | {{KH_ModifiedTime}} |
| Business unit | {{KH_Fachbereich}} |
| Corporate domain | {{KH_Konzerndomaene}} |
| Current version | 1.0 |
| Status | Production |
| Last updated | {{KH_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 Goal & Context

### 3.1 Objective
{{KH_Zielsetzung}}

### 3.2 Business Use Case
{{KH_Anwendungsfall}}

### 3.3 Downstream Consumers (semantic models / reports / real-time dashboards)
{{KH_Konsumenten}}

---

## 4. Structure & Access

### 4.1 Connection & Endpoints

{{KH_EndpunktTabelle}}

### 4.2 Database Schema (tables / functions / materialized views)
{{KH_Schema}}

---

## 5. Data Sources & Loading

### 5.1 Data Sources / Upstream Processes

{{KH_DatenquellenTabelle}}

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

---

## 6. Content & Usage

{{KH_ServiceHinweis}}

### 6.1 Access via the Query Endpoint
{{KH_EndpointHinweis}}

### 6.2 Parameters & Configuration
{{KH_ParameterHinweis}}

### 6.3 Data Quality

- Handling of NULL/missing values: {{KH_NullHandling}}
- Data validation rules: {{KH_Validierungsregeln}}
- Retention / caching policy: {{KH_Aufbewahrung}}

### 6.4 Performance Notes

- Update policies / materialized views: {{KH_Optimierung}}
- Known performance bottlenecks: {{KH_PerformanceHinweise}}
- Further measures: {{KH_Optimierungen}}

---

## 7. Operations & Maintenance

### 7.1 Loading & Orchestration

{{KH_Beladung}}

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

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

---

## 8. Security & Permissions

### 8.1 Access & Sharing
{{KH_Zugriffe}}

### 8.2 Sensitivity Labels
{{KH_Labels}}

### 8.3 Risks & Limitations
{{KH_Risiken}}

---

## 9. Versioning & Change History

### 9.1 Repository / Storage
{{KH_Repository}}

### 9.2 Change Log

| Version | Date | Change | Type (business/technical) | Author |
|-------|-------|---------|--------------------------|-------|
| 1.0 | {{KH_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)
