pyspark-patterns

Standardize PySpark ETL workflows with DataFrame utilities for deduplication and change detection.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/linus-mcmanamey/multi-agent-user-story-development --skill pyspark-patterns
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: pyspark-patterns
Source: https://github.com/linus-mcmanamey/multi-agent-user-story-development/tree/main/.claude/skills/pyspark-patterns
Command: npx skills add https://github.com/linus-mcmanamey/multi-agent-user-story-development --skill pyspark-patterns

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a comprehensive guide to PySpark best practices, standardized ETL patterns, and efficient DataFrame operations, eliminating guesswork and ensuring consistent, high-quality PySpark code. It helps developers write and debug PySpark code more effectively, reducing errors and development time.

Core Features & Use Cases

  • Standardized ETL Patterns: Follow a consistent Extract-Transform-Load structure for all data transformations.
  • Optimized DataFrame Operations: Leverage TableUtilities for common tasks like deduplication, hashing, and timestamp cleaning.
  • Robust Logging & Error Handling: Implement NotebookLogger and @synapse_error_print_handler for clear, consistent operational insights and error management.
  • Use Case: When building a new data pipeline, use this skill to quickly recall the project's preferred PySpark patterns for data ingestion, transformation, and loading, ensuring your code adheres to established standards.

Quick Start

Explain the project's PySpark ETL pattern for a new silver layer table named 's_customer_data' from 'bronze_db.b_customer_raw'.

Frequently Asked Questions about pyspark-patterns

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

FAQPage Schema
How do I build a standardized ETL pipeline in PySpark?

A standardized ETL pipeline in PySpark follows a consistent Extract-Transform-Load structure using DataFrame operations. This Skill provides proven patterns for data ingestion, transformation, and loading that ensure code adheres to established standards and reduces development time across your data workflows.

What's the best way to deduplicate and clean PySpark DataFrames?

Use TableUtilities methods for deduplication, timestamp normalization, and hash-based change detection. This approach provides consistent, reusable DataFrame operations that eliminate guesswork and ensure high-quality transformations across your pipelines.

How do I implement logging and error handling in PySpark notebooks?

Implement NotebookLogger and @synapse_error_print_handler for robust, consistent operational insights and error management. These utilities provide clear visibility into pipeline execution and simplify debugging in notebook environments.

Can I use PySpark patterns for data migration and analytics pipelines?

Yes. PySpark patterns work across data migration and analytics pipelines requiring robust ETL transformations, timestamp normalization, last-N-years filtering, and prevention of full dataset processing in local development environments.

How do I prevent processing entire datasets during PySpark development?

Use controlled ETL workflows with filtering methods from TableUtilities to limit dataset scope during development. This prevents inefficiencies and resource waste while testing transformations locally before running against production data.