sqldw-authoring-cli - Author T-SQL in Fabric from the CLI
Execute authoring T-SQL for schema changes, data operations, ingestion, transactions, and programmable objects against Microsoft Fabric Data Warehouse and SQL endpoints.
Tags
Updated: 2026-10-15Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Find Fabric workspaces and items
- Authenticate to Fabric APIs
- Connect to SQL endpoints
- Execute DDL and DML
- Ingest data with COPY INTO
- Ingest data with OPENROWSET
- Manage warehouse transactions
- Create stored procedures
- Create views and functions
- Perform schema evolution
- Use time travel and snapshots
- Generate ETL and ELT scripts
- Refresh SQL endpoint metadata
Inputs
- Fabric workspace name or ID
- Fabric item name, type, or ID
- T-SQL statements or scripts
- Fabric credentials or tokens
- SQL endpoint connection details
- Source data paths
Outputs
- Query results and execution messages
- Created or modified database objects
- Inserted, updated, or deleted data
- Data ingestion status
- Transaction status
- ETL or ELT shell scripts
- Refreshed SQL endpoint metadata
Requirements
- Agentic CLI environment
- Microsoft Fabric access
- Data Warehouse or SQL endpoint
- Entra authentication
- Required API and database permissions
- Update check on first session use