Diagnose warehouse issues with sqldw-cli in Microsoft Fabric

The Warehouse operations skill sqldw-cli is a diagnostic tool designed to investigate performance and operational issues in warehouses and SQL analytics endpoints within Microsoft Fabric. It runs bounded, read-only analyses, providing evidence, recommended actions, and validation steps.

Use cases

Imagine you need to troubleshoot a slow-running warehouse without altering the production environment. With this tool, you can:

• Run controlled, read-only diagnostics on workloads.
• Gather technical evidence regarding failures or bottlenecks.
• Receive remediation recommendations and validation steps.

How to use

sqldw-cli diagnose --workspace my_workspace --warehouse my_warehouse

What happens in this code:

1. The command invokes the sqldw-cli tool with the diagnose action.
2. The workspace parameter specifies the target workspace.
3. The warehouse parameter points to the specific warehouse being checked.

Limitations and requirements

• Generally Available (GA).
• Performs read-only operations and bounded diagnostics.