skills.rest
rritec
rritecCOMMUNITY
Explore all skills by this author →
Website𝕏@rritecGitHub

sqldw-authoring-cli

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

3|6|Updated Jun 21, 2024
Search Tags:#etl#data warehouse#time travel#sqlcmd#t-sql#microsoft fabric#copy into
One-click install
npx skills add https://github.com/rritec/Microsoft-Fabric --skill sqldw-authoring-cli-rritec
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqldw-authoring-cli
Source: https://github.com/rritec/Microsoft-Fabric/tree/main/skills/plugins/fabric-authoring/skills/sqldw-authoring-cli
Command: npx skills add https://github.com/rritec/Microsoft-Fabric --skill sqldw-authoring-cli-rritec

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill removes the friction of safely authoring Microsoft Fabric Warehouse and SQL endpoint changes from a command-line workflow, so you can create, load, transform, and repair data without switching tools or guessing at Fabric-specific behavior.

Core Features & Use Cases

  • T-SQL Authoring: Create and modify tables, views, functions, and stored procedures for Fabric Warehouse and supported SQL endpoints.
  • Data Operations: Run inserts, updates, deletes, merges, COPY INTO ingestion, OPENROWSET transforms, transactions, and schema evolution patterns.
  • Operational Guidance: Discover workspace and item IDs, connect with sqlcmd, verify schema before writing, and troubleshoot Fabric-specific errors and performance issues.
  • Use Case: A data engineer needs to load parquet files into a warehouse, upsert the latest batch, validate row counts, and preserve safe rollback options, all from a scripted CLI flow.

Quick Start

Use this skill to generate a safe sqlcmd-based Fabric SQL authoring workflow for your target warehouse or SQL endpoint after discovering the schema and connection details.

Frequently Asked Questions about sqldw-authoring-cli

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

FAQPage Schema
How do I author T-SQL for a Microsoft Fabric Warehouse from the command line?▼

To run Fabric SQL operations from the CLI, you need az CLI for authentication, sqlcmd for executing commands, and valid Fabric workspace and item IDs to establish the connection.

What is the best way to load parquet files into a Fabric Warehouse using T-SQL?▼

You can load parquet files into a Fabric Warehouse by executing the COPY INTO T-SQL command via sqlcmd, enabling scripted data ingestion and transformation within agentic ETL workflows.

Can I run data operations like upserts and transactions in a Fabric SQL endpoint?▼

Yes, you can run data operations like inserts, updates, deletes, merges, and transactions in a Fabric SQL endpoint by executing T-SQL statements through a sqlcmd connection.

Does Microsoft Fabric SQL support time travel for safe rollback operations?▼

Yes, Microsoft Fabric SQL supports time travel, allowing you to preserve safe rollback options and query historical data states directly from your CLI workflow.

How do I troubleshoot Fabric-specific T-SQL errors and performance issues?▼

You troubleshoot Fabric-specific T-SQL errors and performance issues by verifying your schema before writing, checking connection constraints, and following operational guidance for agentic ETL workflows.

Related Skills

Explore More Data & Analytics Skills→
patrikboroschpatrikborosch
14

sqldw-consumption-cli

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

Community
Intermediate
Sir-chawakornSir-chawakorn
9

diff-table-parity

Compare two datasets for row counts, key differences, and column value mismatches.

Community
Advanced
patrikboroschpatrikborosch
14

sqldw-authoring-cli

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

Community
Advanced
weiflycc-cmdweiflycc-cmd

sqldw-authoring-cli

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

Community
Advanced