skills.rest
patrikborosch
patrikboroschCOMMUNITY
Explore all skills by this author →
GitHub

sqldw-authoring-cli

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

14|3|Updated Mar 13, 2026
Search Tags:#data ingestion#data warehouse#schema evolution#sqlcmd#cli automation#microsoft fabric#t-sql authoring
One-click install
npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill sqldw-authoring-cli-patrikborosch
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqldw-authoring-cli
Source: https://github.com/patrikborosch/AnalyticsPlatformAgents/tree/main/creator/skills/sqldw-authoring-cli
Command: npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill sqldw-authoring-cli-patrikborosch

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the need for GUI tools to manage Microsoft Fabric Data Warehouse and SQL endpoint T-SQL operations, enabling automated, agent-driven data platform workflows directly from terminal environments for tasks like table creation, data loading, and schema management.

Core Features & Use Cases

  • T-SQL Authoring: Execute DDL (CREATE/ALTER/DROP tables), DML (INSERT/UPDATE/DELETE/MERGE), and stored procedure management for Fabric Data Warehouses and Lakehouse SQL endpoints.
  • Data Ingestion: Run COPY INTO and OPENROWSET operations to load Parquet, CSV, and other data from ADLS Gen2 and OneLake into warehouse tables.
  • Schema & Transaction Management: Handle schema evolution, transaction control, time travel queries, snapshot recovery, and ETL/ELT script generation for production data pipelines.
  • Use Case: For example, use this skill to automate an incremental upsert of daily sales data from a staging table to a production fact table, with built-in retry logic for snapshot conflicts.

Quick Start

Use the sqldw-authoring-cli skill to run a T-SQL upsert of the latest staging sales data into the production FactSales table in your Fabric Data Warehouse, with automatic retry for snapshot conflicts.

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 authoring operations against a Microsoft Fabric Data Warehouse from the command line?▼

You can execute T-SQL authoring operations against a Microsoft Fabric Data Warehouse from the command line by using the Go-based sqlcmd tool within agentic CLI environments to run DDL, DML, and data ingestion scripts directly from the terminal.

Can I load data from ADLS Gen2 into Fabric Data Warehouse tables using CLI automation?▼

Yes, you can load data from ADLS Gen2 into Fabric Data Warehouse tables using CLI automation by running COPY INTO and OPENROWSET operations to ingest file formats like Parquet and CSV directly into your warehouse.

Does the sqlcmd tool support schema evolution and transaction control for Microsoft Fabric?▼

The sqlcmd tool supports schema evolution and transaction control for Microsoft Fabric by enabling you to execute T-SQL commands for creating, altering, and dropping tables, managing transactions, and generating ETL scripts.

What prerequisites are needed to automate Fabric SQL warehouse T-SQL tasks from an agentic CLI?▼

To automate Fabric SQL warehouse T-SQL tasks from an agentic CLI, you need the Go-based sqlcmd tool, Azure CLI authentication, and JMESPath filtering for deterministic workspace and item discovery within your terminal environment.

How do I handle snapshot conflicts during an incremental upsert in a Fabric Data Warehouse?▼

To handle snapshot conflicts during an incremental upsert in a Fabric Data Warehouse, you can leverage terminal-based workflows with built-in retry logic and time travel snapshot recovery features provided through T-SQL execution.

What is the best way to manage stored procedures and time travel queries for Fabric SQL endpoints?▼

The best way to manage stored procedures and time travel queries for Fabric SQL endpoints is through terminal-based CLI automation, allowing you to author T-SQL directly and perform deterministic, production-ready data platform operations without GUI tools.

Related Skills

Explore More Data & Analytics Skills→
weiflycc-cmdweiflycc-cmd

sqldw-authoring-cli

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

Community
Advanced
muzhicaomingwangmuzhicaomingwang
3

data-warehouse

Consolidate data sources into a single source of truth for analytics.

Community
Advanced
fgarofalo56fgarofalo56
6

microsoft-fabric

Manage Microsoft Fabric resources and OneLake files via public APIs.

Community
Advanced
rritecrritec
3

sqldw-authoring-cli

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

Community
Advanced