skills.rest
microsoft
microsoftOFFICIAL
Explore all skills by this author →
Website𝕏@OpenAtMicrosoftGitHub

sqldw-consumption-cli

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

952|267|Updated Feb 17, 2026
Search Tags:#cli#sql#read-only#export#fabric#data-warehouse#lakehouse
One-click install
npx skills add https://github.com/microsoft/skills-for-fabric --skill sqldw-consumption-cli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqldw-consumption-cli
Source: https://github.com/microsoft/skills-for-fabric/tree/main/plugins/fabric-skills/skills/sqldw-consumption-cli
Command: npx skills add https://github.com/microsoft/skills-for-fabric --skill sqldw-consumption-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Execute read-only T-SQL queries against Fabric Data Warehouse, Lakehouse, and Mirrored Databases from the CLI to enable quick data validation, exploration, and lightweight reporting without GUI tools.

Core Features & Use Cases

  • Query read-only T-SQL against warehouse, lakehouse SQL endpoints, and mirrored databases.
  • Count rows, discover schemas/columns, and generate T-SQL scripts for reuse.
  • Export results to CSV/JSON and monitor basic SQL performance from the command line.

Quick Start

Ask the CLI to run a read-only SQL query against a lakehouse or warehouse endpoint and export the results.

Frequently Asked Questions about sqldw-consumption-cli

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

FAQPage Schema
How do I run read-only SQL queries against Fabric Data Warehouse from the CLI?▼

To run read-only SQL queries against Fabric Data Warehouse from the CLI, use this tool to execute T-SQL via sqlcmd after authenticating with az login, enabling quick data validation and exploration without GUI tools.

Can I export Fabric Lakehouse SQL endpoint query results to CSV or JSON?▼

Yes, you can export Fabric Lakehouse SQL endpoint query results to CSV or JSON. The tool executes read-only T-SQL against lakehouse endpoints and directly outputs the retrieved data into your chosen file format.

What is needed to discover schemas and count rows in a Fabric Mirrored Database?▼

To discover schemas and count rows in a Fabric Mirrored Database, you need az login for authentication and the CLI to execute read-only T-SQL via sqlcmd, leveraging REST-based endpoint discovery for access.

Does this CLI tool enforce read-only access for Lakehouse and Mirrored Database endpoints?▼

Yes, the tool enforces read-only access for Lakehouse and Mirrored Database endpoints. This ensures safe data exploration, row counting, and schema discovery without risking accidental modifications to your underlying Fabric data.

What are the limitations of using CLI for Fabric Data Warehouse queries?▼

Limitations include being restricted to read-only T-SQL operations for lakehouse and mirrored endpoints, requiring az login for authentication, and depending on REST-based endpoint discovery to access Fabric data.

Related Skills

Explore More Data & Analytics Skills→
patrikboroschpatrikborosch
14

eventhouse-consumption-cli

Runs read-only KQL queries against Microsoft Fabric Eventhouse via command-line.

Community
Intermediate
fatihkanfatihkan
7

data-analytics

Analyze datasets and generate analytics reports with visuals.

Community
Advanced
patrikboroschpatrikborosch
14

sqldw-consumption-cli

Query Microsoft Fabric SQL endpoints with read-only T-SQL via CLI.

Community
Intermediate
wardawgmalviciouswardawgmalvicious
2

fabric-database

Execute SQL statements on Azure SQL Database instances in a Fabric workspace.

Community
Intermediate