Skip to content
Get packs

Fabric Lakehouse Guide

Gives the agent Microsoft Fabric Lakehouse concepts, security, shortcuts and PySpark/data-loading guidance

Source Download skill
Repository
github/awesome-copilot
Stars
40,703
Licence
MIT
Files
3 files

What it does

Once installed, the agent can explain how a Microsoft Fabric Lakehouse is organised (Tables and Files folders, Delta tables, schemas, shortcuts, views), how access control works through workspace roles and OneLake security, and how to tune performance with commands like OPTIMIZE and VACUUM. It can also point you to example PySpark code and guidance on getting data into a Lakehouse. It is a knowledge guide: it teaches the agent context rather than performing actions in your Fabric environment.

Great for

  • Data engineers designing or reviewing a Microsoft Fabric Lakehouse
  • Analysts new to Fabric who want a plain-language explanation of its parts
  • Developers who want PySpark or Spark SQL starting points for Lakehouse tables

Skip it if

  • Anyone needing guaranteed-current Fabric behaviour: the content is a single v1.0 summary and Fabric features change, so verify against Microsoft documentation
  • Non-Fabric platforms (e.g. plain Databricks or Snowflake), where the advice will not apply

Try asking

  • “Explain the difference between internal and external tables in a Fabric Lakehouse”
  • “Design a schema layout for a Lakehouse with shortcuts to ADLS Gen2 data”
  • “How should I run OPTIMIZE and VACUUM on my Delta tables in Fabric?”
  • “Show me how row-level security works for Lakehouse tables”
Step-by-step guide: how to use Fabric Lakehouse GuideInstall, first run, examples, tips and FAQs

Install in 3 steps

  1. 1

    Download the skill

    The ZIP contains the 3 original files, the MIT licence and an attribution note.

    fabric-lakehouse.zip
  2. 2

    Add it to your agent

    Claude Code (all projects)

    mkdir -p ~/.claude/skills && unzip fabric-lakehouse.zip -d ~/.claude/skills/

    Claude Code / Agent SDK (this project only)

    mkdir -p .claude/skills && unzip fabric-lakehouse.zip -d .claude/skills/

    Claude apps (web/desktop): Settings → Capabilities → Skills → Upload skill, and choose the ZIP.

  3. 3

    Ask for the task

    No special command needed — the agent reads the skill's description and loads it when your request matches. Try one of the prompts above.

Get better results

  • Ask for a specific task (design, optimise, load data) so the agent pulls the relevant section rather than a general overview.
  • Check any generated PySpark or security settings against current Microsoft Fabric documentation before running them in production.
  • Provide your workspace and data source details so the agent can tailor shortcut and access-control advice.

What's inside

  • references/getdata.md
  • references/pyspark.md
  • SKILL.md

Redistributed unmodified from github/awesome-copilot under the MIT licence. The assessment was drafted with AI from the skill's files on 2026-10-29. Skills can instruct your agent to run code — read SKILL.md and any scripts before installing.