fabric-lakehouse

# When to Use This Skill Use this skill when you need to: - Generate a document or explanation that includes definition and context about Fabric Lakehouse and its capabilities. - Design, build, and optimize Lakehouse solutions using best practices. - Understand the core concepts and components of a Lakehouse in Microsoft Fabric. - Learn how to manage tabular and non-tabular data within a Lakehouse. # Fabric Lakehouse ## Core Concepts ### What is a Lakehouse? Lakehouse in Microsoft Fabric is an item that gives users a place to store their tabular data (like tables) and non-tabular data (like files). It combines the flexibility of a data lake with the management capabilities of a data warehouse. It provides: - **Unified storage** in OneLake for structured and unstructured data - **Delta Lake format** for ACID transactions, versioning, and time travel - **SQL analytics endpoint** for T-SQL queries - **Semantic model** for Power BI integration - Support for other table formats like CSV, Parquet - Support for any file formats - Tools for table optimization and data management ### Key Components - **Delta Tables**: Managed tables with ACID compliance and schema enforcement - **Files**: Unstructured/semi-structured data in the Files section - **SQL Endpoint**: Auto-generated read-only SQL interface for querying - **Shortcuts**: Virtual links to external/internal data without copying - **Fabric Materialized Views**: Pre-computed tables for fast query performance ### Tabular ...