Diagnose and resolve Apache Spark performance issues in Microsoft Fabric notebooks and Spark Job Definitions. Use when PySpark jobs are slow, notebooks take too long, Spark stages are skewed, shuffles are excessive, out-of-memory errors occur, Delta Lake writes are slow, or Fabric capacity is throttled. Covers data skew, shuffle optimization, broadcast joins, partition tuning, VOrder, Optimized Write, resource profiles, autotune, native execution engine, small file compaction, and Spark UI interpretation. Keywords include slow notebook, OOM, spill, shuffle, skew, broadcast, repartition, coalesce, OPTIMIZE, VACUUM, Z-ORDER, checkpoint, cache, persist, executor memory, driver memory, spark.sql.shuffle.partitions, autoBroadcastJoinThreshold, maxPartitionBytes, Fabric capacity throttling, CU utilization.
$npx -y skills add patrickgallucci/fabric-skills --skill fabric-pyspark-perf-remediateInstalls into the current project.
Run `npx skills use "https://github.com/patrickgallucci/fabric-skills" --skill "patrickgallucci/fabric-skills/fabric-pyspark-perf-remediate"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/patrickgallucci/fabric-skills" that are relevant to the current task. Run `npx skills add "https://github.com/patrickgallucci/fabric-skills"` and select the relevant skills, then follow their instructions.