skills.rest
accelerate-data
accelerate-dataOFFICIAL
Explore all skills by this author →
WebsiteGitHub

fabric-cli-lakehouse

Manage Fabric lakehouses and Delta tables with Fabric CLI commands.

Updated Mar 16, 2026
Search Tags:#data management#data storage#fabric#lakehouse#fabric cli#delta tables
One-click install
npx skills add https://github.com/accelerate-data/vibedata-official --skill fabric-cli-lakehouse
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: fabric-cli-lakehouse
Source: https://github.com/accelerate-data/vibedata-official/tree/main/plugins/fabric-cli/skills/fabric-cli-lakehouse
Command: npx skills add https://github.com/accelerate-data/vibedata-official --skill fabric-cli-lakehouse

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill solves the problem of managing lakehouses and Delta tables in a Fabric environment by providing Fabric CLI commands for operations like creation, inspection, loading data, optimization, and maintenance.

Core Features & Use Cases

  • Lakehouse Management: Create, list, check existence, get details, and delete lakehouses.
  • Table Schema Inspection: Inspect the schema of Delta tables within a lakehouse.
  • Data Loading: Load CSV and Parquet files into Delta tables.
  • Table Optimization: Optimize Delta table file layout for query performance.
  • Table Vacuum: Remove old files no longer referenced by the Delta log.
  • Table Maintenance: Run table maintenance as background jobs.
  • Query Lakehouse Tables: Query lakehouse tables via SQL endpoint.
  • Direct API Access: Access lakehouse and table data through REST API endpoints.
  • Common Patterns: Examples of common tasks like loading CSV data and optimizing tables.
  • Common Issues: Solutions to common issues users might encounter.

Quick Start

Run the command to create a new lakehouse:

uv run --env-file .env fab create ws1.Workspace/lh1.Lakehouse

Frequently Asked Questions about fabric-cli-lakehouse

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

FAQPage Schema
How do I create a Microsoft Fabric lakehouse from the command line?▼

You can create a Fabric lakehouse from the command line by running the Fabric CLI command `fab create ws.Workspace/lh.Lakehouse`, which provisions the lakehouse directly within your configured Fabric environment.

How do I load CSV and Parquet files into Delta tables in a Fabric lakehouse?▼

Loading CSV and Parquet files into Delta tables in a Fabric lakehouse is done using Fabric CLI commands, which ingest the source files and register them as queryable Delta tables within the target lakehouse.

Can I inspect the schema of Delta tables in a Fabric lakehouse without opening the UI?▼

Yes, you can inspect Delta table schemas without the UI by using Fabric CLI commands, which query the lakehouse metadata and return the table schema details directly in your terminal environment.

What is the best way to optimize Delta table file layout for query performance in Fabric?▼

The best way to optimize Delta table file layout for query performance in Fabric is by running the Fabric CLI table optimization commands, which compact small files and reorganize data layout for faster queries.

Do I need the Fabric CLI installed to manage lakehouses and run table maintenance?▼

Yes, you need the Fabric CLI installed and configured in your environment, as this Skill relies on Fabric CLI commands to execute lakehouse creation, data loading, table maintenance, and vacuum operations.

How do I vacuum Delta tables to remove old files in a Fabric lakehouse?▼

To vacuum Delta tables and remove old files no longer referenced by the Delta log in a Fabric lakehouse, you run the specific Fabric CLI vacuum commands provided for table maintenance.

Related Skills

Explore More Data & Analytics Skills→
rritecrritec
3

spark-consumption-cli

Analyze Microsoft Fabric lakehouse data with interactive PySpark sessions and Spark SQL.

Community
Advanced
microsoftmicrosoft
952

sqldw-consumption-cli

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

Official
Intermediate
JaviMontanoJaviMontano

metodologia-data-engineering

Automate data platform architecture design for ingestion, storage, quality, and observability.

Community
Advanced
markus41markus41
12

Fabric OneLake

Build lakehouses and configure workspace identity for cross-workspace data sharing via OneLake.

Community
Advanced