fabric-warehouse-extract

Extract DDL and metadata from Microsoft Fabric Warehouse schemas using SQL queries.

Updated May 26, 2026

Search Tags:#metadata extraction #data backup #data documentation #Microsoft Fabric #DDL extraction

Ready to run

npx skills add https://github.com/rbutinar/ade-ops --skill fabric-warehouse-extract

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: fabric-warehouse-extract
Source: https://github.com/rbutinar/ade-ops/tree/main/.agents/skills/fabric-warehouse-extract
Command: npx skills add https://github.com/rbutinar/ade-ops --skill fabric-warehouse-extract

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pyodbc, msal, pyyaml, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill extracts DDL (views, procedures) and object lists from a Microsoft Fabric Warehouse, providing a quick way to analyze, document, or backup data without manual scripting.

Core Features & Use Cases

DDL Extraction: Extracts views, procedures, and table data as SQL.
Schema and System Catalogs: Support for all configured schemas and system catalogs (INFORMATION_SCHEMA, sys.objects).
Comparative Analysis: Optionally compare extracted objects against a target list to identify differences.
Use Case: Automate the creation of data documentation and backup for your Microsoft Fabric Warehouse by simply running the Skill.

Quick Start

To extract all schemas, use the command: /fabric-warehouse-extract all --env development

Frequently Asked Questions about fabric-warehouse-extract

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

FAQPage Schema

How do I extract DDL from a Microsoft Fabric Warehouse?▼

Extracting DDL from a Microsoft Fabric Warehouse involves querying schemas and system catalogs like INFORMATION_SCHEMA and sys.objects. This Skill automates pulling views, procedures, and table data as SQL to generate documentation and data backups.

What is the best way to automate Microsoft Fabric Warehouse metadata documentation?▼

Automating Microsoft Fabric Warehouse metadata documentation is best achieved by extracting DDL and object lists via SQL queries. This Skill compares extracted objects against optional configuration files to identify differences and backup data.

Can I compare extracted Fabric Warehouse schemas against a target list?▼

Yes, you can compare extracted Fabric Warehouse schemas against a target list. This Skill supports comparative analysis by optionally checking extracted objects against configuration files to identify metadata differences.

Do I need pyodbc and msal to extract Microsoft Fabric Warehouse schemas?▼

Yes, you need pyodbc and msal to extract Microsoft Fabric Warehouse schemas. These dependencies facilitate the SQL queries and authentication required to pull DDL and metadata from system catalogs.

How do I backup Microsoft Fabric Warehouse views and procedures?▼

To backup Microsoft Fabric Warehouse views and procedures, you extract the DDL as SQL scripts. This Skill queries schemas and system catalogs to retrieve and save procedure and view definitions for automated data backup.