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

sqldw-authoring-cli

Execute authoring SQL against Microsoft Fabric Data Warehouse endpoints via CLI.

952|267|Updated Feb 17, 2026
Search Tags:#cli#sql#ingestion#fabric#dml#schema-evolution#ddl
One-click install
npx skills add https://github.com/microsoft/skills-for-fabric --skill sqldw-authoring-cli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqldw-authoring-cli
Source: https://github.com/microsoft/skills-for-fabric/tree/main/plugins/fabric-authoring/skills/sqldw-authoring-cli
Command: npx skills add https://github.com/microsoft/skills-for-fabric --skill sqldw-authoring-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This CLI skill enables developers and data engineers to author, deploy, and manage SQL against Microsoft Fabric Data Warehouse endpoints from a command-line interface, reducing setup time and enabling repeatable, scriptable workflows.

Core Features & Use Cases

  • DDL and DML authoring (CREATE, ALTER, DROP; INSERT, UPDATE, DELETE, MERGE) against Fabric DW.
  • Data ingestion and transformation via CLI (COPY INTO, OPENROWSET) and schema evolution workflows.
  • End-to-end workflows for development, testing, and CI/CD by scripting common tasks like provisioning tables, ingesting data, and validating results.

Quick Start

Create a new table in your Fabric DW and load initial data using the CLI.

Frequently Asked Questions about sqldw-authoring-cli

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

FAQPage Schema
How do I execute DDL and DML authoring against a Microsoft Fabric Data Warehouse from the command line?▼

You can author DDL and DML against Fabric Data Warehouse from the command line by using a CLI workflow that executes SQL scripts for schema management and data manipulation tasks.

What's the best way to automate schema evolution and data ingestion in Fabric DW via CI/CD?▼

The best way to automate schema evolution and data ingestion in Fabric DW is using a CLI workflow that integrates with CI/CD pipelines to script provisioning, ingesting data via COPY INTO, and validating results.

Do I need az CLI and sqlcmd to manage SQL workflows on Fabric Data Warehouse endpoints?▼

Yes, you need az CLI and sqlcmd Go to manage SQL workflows on Fabric Data Warehouse endpoints, as they handle authentication, endpoint discovery, and deployment requirements.

Can I perform data ingestion and transformation using OPENROWSET directly through a CLI on Fabric DW?▼

Yes, you can perform data ingestion and transformation using OPENROWSET and COPY INTO commands directly through a CLI workflow targeting Microsoft Fabric Data Warehouse endpoints.

Does this CLI approach support ad-hoc schema changes in Fabric DW production environments?▼

Yes, this CLI approach supports ad-hoc schema evolution in Fabric DW production environments by enforcing deterministic patterns via REST API discovery and OneLake data access considerations.

How does project bootstrapping work for SQL development on Fabric Data Warehouse?▼

Project bootstrapping for SQL development on Fabric Data Warehouse works by scripting common development tasks like provisioning tables and loading initial data via a structured CLI workflow.

Related Skills

Explore More Software Engineering Skills→
microsoftmicrosoft
952

sqldw-operations-cli

Analyze Fabric Data Warehouse performance and diagnostics via CLI.

Official
Advanced
weiflycc-cmdweiflycc-cmd

sqldw-authoring-cli

Execute T-SQL DDL, DML, ingestion, and recovery against Fabric Data Warehouse.

Community
Advanced
rritecrritec
3

spark-consumption-cli

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

Community
Advanced
rbutinarrbutinar

fabric-sql-deploy

Deploy SQL DDL scripts to a Microsoft Fabric Warehouse with pyodbc and Azure AD authentication.

Community
Advanced