Fabric Data Warehouse

What problem does it solve?

Fabric Data Warehouse provides a comprehensive, scalable environment to build and operate enterprise-grade data warehouses on Microsoft Fabric. It enables provisioning and managing warehouses, authoring T-SQL DDL/DML and stored procedures, and applying robust security and governance controls across workspaces. This skill helps data engineers and analysts accelerate analytic delivery by combining cross-database queries, secure data sharing, and fast data loading.

Core Features & Use Cases

• Warehouse provisioning & management: create, scale, and monitor Fabric warehouses; auto-distributed storage and CTAS/MERGE flows for ETL.
• T-SQL DDL/DML & stored procedures: full DDL/DML surface, upserts, transactions, and reusable logic encapsulation.
• Cross-database and lakehouse integration: query data across Fabric databases and lakehouse endpoints with three-part naming.
• Security & governance: implement RLS, CLS, dynamic masking, and formal permission models for data access.
• Data loading & transformation: load data with COPY INTO, transform with CTAS/MERGE, and orchestrate pipelines via Dataflow Gen2 and Copy activities.
• Performance & monitoring: leverage Query Insights, statistics, and Fabric’s auto-distribution to optimize query performance.

Quick Start

Create a new Fabric warehouse in your workspace and begin modeling your first star-schema data warehouse.