fabric-warehouse-test

Check Microsoft Fabric Warehouse schema permissions via ODBC with pyodbc and msal.

Updated May 26, 2026
One-click install
npx skills add https://github.com/rbutinar/ade-ops --skill fabric-warehouse-test
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: fabric-warehouse-test
Source: https://github.com/rbutinar/ade-ops/tree/main/.agents/skills/fabric-warehouse-test
Command: npx skills add https://github.com/rbutinar/ade-ops --skill fabric-warehouse-test

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pyodbc, msal, and includes scripts (resource) components.

What problem does it solve?

This Skill ensures proper read/write permissions are in place for a Microsoft Fabric Warehouse schema, aiding in the diagnosis of deployment readiness or permission issues.

Core Features & Use Cases

  • Permission Testing: Runs a set of predefined read/write probes on a Fabric Warehouse schema.
  • Schema Validation: Checks for schema existence and object readability.
  • Test Automation: Automates the creation and deletion of test views and tables.
  • Use Case: For onboarding new users to a workspace to confirm their grants before deploying changes.

Quick Start

Execute the /fabric-warehouse-test command with the schema name and environment to run the permission test.

Frequently Asked Questions about fabric-warehouse-test

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

FAQPage Schema
How do I verify read/write permissions on a Microsoft Fabric Warehouse schema?

You can verify read/write permissions on a Microsoft Fabric Warehouse schema by running predefined probes that test schema existence, object readability, and the ability to create and delete views and tables.

Do I need MSAL authentication to test Fabric Warehouse schema permissions?

Yes, MSAL authentication is required to test Fabric Warehouse schema permissions. The process uses the msal package for authentication alongside pyodbc for ODBC connectivity to execute the permission checks.

How can I automate schema validation for new users onboarding to a Fabric Warehouse?

Automate schema validation for new users by executing a command with the schema name and environment to run predefined permission tests, confirming their deployment readiness and grants before applying changes.

What does a Fabric Warehouse permission test check for?

A Fabric Warehouse permission test checks for schema existence, object readability, and the ability to create and delete views and tables to ensure proper read/write permissions are in place for diagnosing deployment readiness.

Does pyodbc work with Microsoft Fabric Warehouse for permission testing?

Yes, pyodbc works with Microsoft Fabric Warehouse for permission testing by providing the required ODBC connectivity to run schema existence checks and test the creation and deletion of views and tables.

Why does my Fabric Warehouse schema permission testing fail during deployment?

Your Fabric Warehouse schema permission testing may fail during deployment if proper read/write grants are missing. Running automated probes helps diagnose these readiness issues by checking object readability and view creation.