skills.rest
weiflycc-cmd
weiflycc-cmdCOMMUNITY
Explore all skills by this author →
GitHub

sqldw-authoring-cli

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

Updated Jun 1, 2026
Search Tags:#data ingestion#etl#schema evolution#fabric#cli automation#t-sql#sql warehouse
One-click install
npx skills add https://github.com/weiflycc-cmd/skills-for-fabric --skill sqldw-authoring-cli-weiflycc-cmd
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqldw-authoring-cli
Source: https://github.com/weiflycc-cmd/skills-for-fabric/tree/main/plugins/fabric-authoring/skills/sqldw-authoring-cli
Command: npx skills add https://github.com/weiflycc-cmd/skills-for-fabric --skill sqldw-authoring-cli-weiflycc-cmd

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the need to manually switch between the Fabric portal and terminal for Data Warehouse authoring tasks, enabling data engineers to execute all T-SQL DDL, DML, ingestion, and ETL operations directly from CLI environments for faster, repeatable, and scriptable workflows.

Core Features & Use Cases

  • Full T-SQL Authoring Support: Execute DDL (CREATE/ALTER/DROP tables, schemas), DML (INSERT/UPDATE/DELETE/MERGE), COPY INTO/OPENROWSET data ingestion, transaction management, stored procedure deployment, and time travel data recovery against Fabric Data Warehouses and SQL endpoints.
  • Agentic Workflow Guardrails: Built-in schema discovery steps, validation checklists, and troubleshooting guides to prevent common errors like snapshot conflicts, incorrect authentication, or data type mismatches.
  • Reusable Script Templates: Pre-built Bash and PowerShell templates for common patterns including incremental upserts with retry logic, schema migrations via CTAS workarounds, and end-to-end ELT pipelines.
  • Use Case: A data engineer can use this Skill to deploy a new warehouse table, load 1M rows of sales data from ADLS Gen2, run an incremental upsert of new records, and recover accidentally deleted data via time travel, all without leaving the terminal.

Quick Start

Use the sqldw-authoring-cli skill to create a new dbo.FactSales table in your Fabric Data Warehouse and load 1000 rows of sample sales data from an ADLS Gen2 Parquet file using COPY INTO.

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 T-SQL data ingestion and schema evolution for Fabric SQL Warehouse from the command line?▼

You can execute T-SQL data ingestion and schema evolution for Fabric SQL Warehouse by running DDL, DML, and COPY INTO operations directly from terminal environments using a CLI authoring skill. This eliminates manual portal switching for data engineering workflows.

What do I need to set up before authoring T-SQL against a Fabric Data Warehouse via CLI?▼

Before authoring T-SQL against a Fabric Data Warehouse via CLI, you need the Go-based sqlcmd CLI tool installed, an active Azure CLI authentication session, and valid connection parameters for your Fabric workspace and warehouse SQL endpoint.

Can I recover accidentally deleted data in a Fabric SQL Warehouse using the command line?▼

Yes, you can recover accidentally deleted data in a Fabric SQL Warehouse using the command line through time travel data recovery operations. The CLI authoring skill supports time travel recovery alongside standard DML and transaction management tasks.

How do I automate incremental upserts and ELT pipelines for Fabric Data Warehouse?▼

You can automate incremental upserts and ELT pipelines for Fabric Data Warehouse by deploying pre-built Bash and PowerShell script templates. These templates include retry logic, schema migrations via CTAS workarounds, and end-to-end pipeline execution patterns.

Does the Fabric SQL Warehouse CLI authoring skill support stored procedure deployment?▼

Yes, the Fabric SQL Warehouse CLI authoring skill supports stored procedure deployment alongside full T-SQL authoring capabilities including DDL, DML, data ingestion, and transaction management. It applies to data engineering workflows requiring terminal-based scriptable operations.

What are the limitations of using CLI automation for Fabric SQL Warehouse authoring?▼

Limitations of using CLI automation for Fabric SQL Warehouse authoring include potential snapshot conflicts, data type mismatches, and incorrect authentication errors. Built-in validation checklists and troubleshooting guides help prevent these common CLI automation issues.

Related Skills

Explore More Data & Analytics Skills→
rritecrritec
3

sqldw-authoring-cli

Author Microsoft Fabric Warehouse T-SQL via sqlcmd CLI workflows.

Community
Advanced
RanNahmanyRanNahmany
7

business-intelligence

Guide dashboard design, KPI frameworks, and reporting automation for analytics professionals.

Community
Advanced
microsoft-foundrymicrosoft-foundry
56

azure-ai-fine-tuning

Automate end-to-end Azure AI Foundry fine-tuning workflows with dataset prep, training, evaluation, and deployment.

Official
Advanced
patrikboroschpatrikborosch
14

sqldw-consumption-cli

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

Community
Intermediate