skills.rest
markus41
markus41COMMUNITY
Explore all skills by this author →
GitHub

Fabric Data Warehouse

Provision Fabric Data Warehouse resources and author T-SQL DDL/DML.

12|4|Updated Mar 1, 2026
Search Tags:#security#cross-database#fabric#data-warehouse#t-sql#query-insights
One-click install
npx skills add https://github.com/markus41/Claude-m --skill fabric-data-warehouse
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Fabric Data Warehouse
Source: https://github.com/markus41/Claude-m/tree/main/fabric-data-warehouse/skills/fabric-data-warehouse
Command: npx skills add https://github.com/markus41/Claude-m --skill fabric-data-warehouse

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about Fabric Data Warehouse

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a scalable data warehouse in Microsoft Fabric?▼

To build a scalable Fabric data warehouse, you provision resources within a workspace and author star-schema models using T-SQL DDL. This approach leverages auto-distributed storage to streamline enterprise analytics delivery.

Can I run cross-database queries between Fabric warehouses and lakehouses?▼

Yes, Fabric data warehouses support cross-database queries using three-part naming. This allows you to query data across Fabric databases and lakehouse endpoints directly without moving data.

How do I load data into a Fabric data warehouse?▼

You load data into a Fabric data warehouse using the COPY INTO command. You can also transform loaded data with CTAS and MERGE statements, orchestrating the pipelines via Dataflow Gen2 and Copy activities.

What security features are available for Fabric data warehouses?▼

Fabric data warehouses provide robust security and governance features including Row-Level Security (RLS), Column-Level Security (CLS), and dynamic data masking to implement formal permission models for data access.

Does Fabric data warehouse support T-SQL stored procedures and transactions?▼

Yes, the Fabric data warehouse provides a full T-SQL DDL and DML surface, including stored procedures, upserts, and transactions to encapsulate reusable logic and manage data operations.

How do I monitor and optimize query performance in Fabric data warehouses?▼

You optimize Fabric data warehouse query performance using Query Insights and statistics. Fabric's auto-distribution automatically manages storage distribution to enhance query execution.

Related Skills

Explore More Data & Analytics Skills→
microsoftmicrosoft
952

sqldw-consumption-cli

Query read-only T-SQL against Fabric Data Warehouse, Lakehouse, and Mirrored Databases via CLI.

Official
Intermediate
victormacaubasvictormacaubas
1

sql-data-analysis

Validate and optimize SQL queries for analytics across data warehouses.

Community
Advanced
markus41markus41
12

Fabric Data Factory

Automate end-to-end data integration and orchestration in Microsoft Fabric Data Factory.

Community
Advanced
christopherlouetchristopherlouet
5

data-pipeline

Design and manage automated ETL/ELT data pipelines using Python, SQL, Airflow, and dbt.

Community
Intermediate