fabric-lakehouse Skill (awesome-copilot): Microsoft Fabric Lakehouse Knowledge

Gives your assistant reference knowledge of the Microsoft Fabric Lakehouse, with PySpark and pipeline examples.

Installs: 8.8K; on skills.sh
Stars: 40.7K; on GitHub
Files: 2; besides SKILL.md
Updated: Oct 2026; last repo commit

This skill is a Fabric Lakehouse reference for your assistant. It covers core concepts, schemas, shortcuts, security, performance tuning and lineage. Two linked files add PySpark examples and ways to get data in.

It works as background knowledge, not as a tool. The SKILL.md names no API key or login, and the skill bundles no scripts. Its PySpark examples include overwrite writes, DELETE and VACUUM, so run them with care.

Good for

Data engineers designing a Lakehouse in Microsoft Fabric
Analysts learning tables, shortcuts and OneLake security
Anyone writing documentation that explains Fabric Lakehouse

Install fabric-lakehouse

Claude Code

Copy this prompt.

Install the fabric-lakehouse skill in Claude Code. Run this command:

npx skills add https://github.com/github/awesome-copilot --skill fabric-lakehouse

Then check that it loaded and tell me how to use it.

2
Paste it into Claude Code. It shows the change and asks before running it.

Requires Node.js.

From its listing on skills.sh. Source.

What's in the skill

When it loads

Use this skill to get context about Fabric Lakehouse and its features for software systems and AI-powered functions. It offers descriptions of Lakehouse data components, organization with schemas and shortcuts, access control, and code examples. This skill supports users in designing, building, and optimizing Lakehouse solutions using best practices.

Sections in SKILL.md

Core Concepts
What is a Lakehouse?
Key Components
Tabular data in a Lakehouse
Schemas for tables in a Lakehouse
Files in a Lakehouse
Fabric Materialized Views
Spark Views
Security
Item access or control plane security
Data access or OneLake Security
Lakehouse Shortcuts
Types of Shortcuts
Performance Optimization
V-Order Optimization
Table Optimization

Key facts

Author: tedvilutis (SKILL.md metadata.author)
License: MIT
Installs on skills.sh: 8,762 (Nov 2, 2026)
GitHub stars: 40,666 for the whole github/awesome-copilot repo (Nov 2, 2026)
Last repo commit: Oct 30, 2026
Audits on skills.sh: Gen Agent Trust Hub: pass, Socket: pass, Snyk: pass
What it includes: 3 files: SKILL.md, references/getdata.md and references/pyspark.md
Skill version: 1.0 (SKILL.md metadata)

What it includes

What a Lakehouse is: OneLake storage, Delta tables, SQL endpoint, shortcuts.
Also covers tables, schemas (default dbo), the Files area, Fabric materialized views and Spark views.
Core concepts
Workspace roles for item access, plus OneLake security based on Microsoft Entra ID.
OneLake security supports column-level and row-level security for tables.
Security
Five types: internal, ADLS Gen2, Amazon S3, Dataverse, Google Cloud Storage.
Shortcuts link to data without copying it.
Shortcuts
V-Order, OPTIMIZE and VACUUM for tables, and automatic lineage tracking.
OPTIMIZE compacts small files and can apply Z-ordering. VACUUM cleans up old files.
Performance and lineage
references/pyspark.md: 10 groups of code from reading data to SCD Type 2.
Includes reads, Delta writes, UPDATE, DELETE and MERGE, schemas, OPTIMIZE, VACUUM and an incremental load.
Read · PySpark code examples
references/getdata.md: Data Factory pipelines with 180+ connectors and 8 activity types.
Lists the activities, including Copy Data, Notebook, Dataflow and Lakehouse Maintenance.
Getting data in

From the official docs

Permissions

Low risk

It runs nothing itself, but its examples overwrite tables and delete rows and old files. Try them on test data first.

What it can do

Read your data
Create and change things
Delete things
Read-only mode

Watch out for

Its examples overwrite and delete data
references/pyspark.md has mode("overwrite") writes, a DELETE FROM statement, VACUUM and UPDATE examples. Check table names and run them on test data first. github.com

Technical details

Turning on read-only	Not applicable. The skill bundles no scripts.
Scopes	None of its own: it is guidance, with code you run yourself

Questions

What does fabric-lakehouse do?

It gives your assistant reference knowledge about the Microsoft Fabric Lakehouse. That covers tables, files, schemas, shortcuts, security, performance tuning and PySpark examples, so it can explain concepts and help design Lakehouse solutions.

Does it connect to my Fabric workspace?

The SKILL.md names no tool, API key or login, and the folder bundles no scripts. It supplies guidance and code examples that you run yourself, for example in a Fabric notebook.

How do I install it?

Use the install box above. The skill is three files: SKILL.md and two reference files that the SKILL.md links to, so keep the references folder with it.

Is it safe?

It bundles no scripts, so installing it runs no code. The PySpark reference shows write-mode examples that overwrite tables, a DELETE statement and VACUUM, which removes old files. Run those only on tables you mean to change.

When does it apply?

The SKILL.md lists four uses: writing a document or explanation about Fabric Lakehouse, designing and optimizing Lakehouse solutions, learning the core components, and managing tabular and non-tabular data.

Which assistants does it work in?

The SKILL.md names no client. It is knowledge only, so the install box offers the Claude app upload as well as the folder and skills CLI routes.

Information

updated Nov 2, 2026

Repository: github/awesome-copilot
Folder: skills/fabric-lakehouse

github/awesome-copilot skills.sh

Sources

Docs, issue trackers and discussions this page is built from.

Show all 3

fabric-lakehouse SKILL.md · github.com
fabric-lakehouse references/getdata.md · github.com
fabric-lakehouse references/pyspark.md · github.com