Copyright (c) 2026 MindMesh Academy. All rights reserved. This content is proprietary and may not be reproduced or distributed without permission.
1.1.3. Fabric Items and Their Relationships
💡 First Principle: Fabric items are the building blocks of analytics solutions. Each item type serves a specific purpose, and understanding their relationships is critical for architecture decisions.
Comparative Table: Fabric Item Types
| Item Type | Primary Purpose | Storage Location | Query Language |
|---|---|---|---|
| Lakehouse | Store and process big data | OneLake (Delta tables + Files) | Spark SQL, PySpark |
| Data Warehouse | Structured analytics | OneLake (Delta tables) | T-SQL |
| KQL Database | Real-time analytics | OneLake | KQL |
| Eventstream | Real-time data ingestion | Transient (routes to destinations) | Visual editor |
| Data Pipeline | Orchestration | Metadata only | Visual + expressions |
| Dataflow Gen2 | Low-code ETL | OneLake staging | Power Query (M) |
| Notebook | Code-based processing | OneLake (output) | PySpark, Spark SQL |
Visual: Item Relationships in a Typical Architecture
Loading diagram...