fabric-lakehouse-views-perf-remediatelisted

Troubleshoot Microsoft Fabric materialized lake views (MLV) performance issues including slow refresh, incremental refresh failures, full refresh fallback, Spark job failures, lineage execution errors, data quality constraint violations, and optimal refresh configuration. Use when diagnosing MLV refresh duration, monitoring MLV runs in Monitor Hub, analyzing Spark logs for MLV failures, enabling change data feed (CDF), resolving delta table not found errors, or optimizing MLV query definitions for incremental refresh eligibility. Covers Spark SQL syntax, TBLPROPERTIES, PARTITIONED BY, CONSTRAINT CHECK ON MISMATCH DROP/FAIL, and custom environment configuration.
PatrickGallucci/fabric-skills · ★ 13 · AI & Automation · score 81

Install: claude install-skill PatrickGallucci/fabric-skills

# Fabric Materialized Lake Views Performance remediate Diagnose and resolve performance issues with materialized lake views (MLVs) in Microsoft Fabric lakehouses. This skill covers refresh optimization, Spark job diagnostics, data quality constraint tuning, and lineage execution remediate. ## When to Use This Skill - MLV refresh runs are taking longer than expected - Incremental refresh is falling back to full refresh unexpectedly - MLV lineage execution shows Failed or Skipped nodes - Spark jobs for MLV refresh are failing with errors - "Delta table not found" errors during MLV creation or refresh - Data quality constraints causing unexpected pipeline failures - Need to enable or verify optimal refresh configuration - Custom Spark environment tuning for MLV workloads - Monitoring and interpreting MLV run history ## Prerequisites - Microsoft Fabric workspace with Lakehouse items - Schema-enabled lakehouse (recommended for MLV support) - Fabric notebook for executing Spark SQL commands - Workspace Admin or Contributor role for scheduling and monitoring - Access to Monitor Hub for viewing MLV run details ## Quick Diagnostics Checklist Run through these checks in order when remediate MLV performance: | Step | Check | Action | | ---- | --------------------- | ------------------------------------------------------------------------- | | 1 | Identify refresh mode | Verify optimal refresh t