skills.rest
rbutinar
rbutinarCOMMUNITY
Explore all skills by this author →
Website𝕏@rbutinarGitHub

fabric-sp-run

Execute and monitor stored procedures on a Microsoft Fabric Warehouse.

Updated May 26, 2026
Search Tags:#automation#monitoring#execution#stored procedures#Microsoft Fabric
One-click install
npx skills add https://github.com/rbutinar/ade-ops --skill fabric-sp-run
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: fabric-sp-run
Source: https://github.com/rbutinar/ade-ops/tree/main/.agents/skills/fabric-sp-run
Command: npx skills add https://github.com/rbutinar/ade-ops --skill fabric-sp-run

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the execution of stored procedures on a Microsoft Fabric Warehouse, simplifying and streamlining the process of running procedures and monitoring their execution.

Core Features & Use Cases

  • Stored Procedure Execution: Execute specific stored procedures or pipelines on a Fabric Warehouse.
  • Live Monitoring: Monitor the execution of procedures using a log table for real-time progress updates.
  • Environment-Specific Execution: Run procedures in different environments with the appropriate configuration.
  • Use Case: Imagine you need to execute a complex stored procedure that involves multiple steps and requires monitoring. This Skill allows you to automate the execution and track its progress without manual intervention.

Quick Start

Execute a stored procedure named 'sp_Materialize_All_Clusters_Master' in the 'dev' environment using the command: /fabric-sp-run sp_Materialize_All_Clusters_Master --env dev

Frequently Asked Questions about fabric-sp-run

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

FAQPage Schema
How do I automate stored procedure execution on a Microsoft Fabric Warehouse?▼

Automating stored procedure execution on Microsoft Fabric is achieved by using a dedicated command-line tool to trigger specific procedures, pipelines, or clusters while tracking live progress via a log table.

Can I monitor Microsoft Fabric stored procedure progress in real-time?▼

Monitoring Microsoft Fabric stored procedure progress in real-time is supported by reading updates from a designated log table, providing visibility into execution status without manual checks.

Do I need a specific environment setup to run Fabric stored procedures?▼

Running Fabric stored procedures requires an active connection to the Microsoft Fabric Warehouse and explicit access permissions to both the target stored procedures and their corresponding log tables.

What is the best way to execute environment-specific stored procedures in Microsoft Fabric?▼

Executing environment-specific stored procedures in Microsoft Fabric is handled by passing the target environment parameter, such as the 'dev' flag, to route the run to the correctly configured Warehouse.

Can I execute pipelines and clusters alongside stored procedures in Microsoft Fabric?▼

Executing pipelines and clusters alongside stored procedures in Microsoft Fabric is supported natively, allowing comprehensive automation of diverse Warehouse workload types through a single interface.

Why use automation scripts for Microsoft Fabric stored procedure execution?▼

Using automation scripts for Microsoft Fabric stored procedure execution eliminates manual intervention, streamlining complex multi-step procedures and ensuring consistent runs across different environments.

Related Skills

Explore More Software Engineering Skills→
markus41markus41
12

Fabric Data Warehouse

Provision Fabric Data Warehouse resources and author T-SQL DDL/DML.

Community
Advanced
no-problem-devno-problem-dev

pipeline-pulse

Cross-analyze pain-log and seed-hunt data to generate weekly Markdown pulse reports.

Official
Advanced
ThomazRossitoThomazRossito
31

fabric-data-factory

Coordinate Microsoft Fabric Data Factory pipelines and Dataflows Gen2 for scalable data ingestion and transformation.

Community
Advanced
rritecrritec
3

sqldw-authoring-cli

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

Community
Advanced