pipeline-architecture-patterns

Outline data pipeline architecture patterns for ETL/ELT design decisions.

13|6|Updated Apr 14, 2026
One-click install
npx skills add https://github.com/baekenough/second-brain --skill pipeline-architecture-patterns
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: pipeline-architecture-patterns
Source: https://github.com/baekenough/second-brain/tree/main/.claude/skills/pipeline-architecture-patterns
Command: npx skills add https://github.com/baekenough/second-brain --skill pipeline-architecture-patterns

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Data engineering teams need consistent, scalable blueprinting for ETL/ELT pipelines, orchestration, and data quality practices to reduce rework and errors.

Core Features & Use Cases

  • Provides Lambda, Kappa, and Medallion architecture guidance for batch and streaming processing.
  • Defines data quality contracts, idempotent upserts, and lineage strategies to improve reliability and observability.
  • Use Case: design a multi-region data lake with bronze-silver-gold layers and event-driven orchestration.

Quick Start

Review your current pipelines against the Lambda, Kappa, and Medallion patterns and map them to bronze-silver-gold layers to begin modernization.

Frequently Asked Questions about pipeline-architecture-patterns

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

FAQPage Schema
What are the Lambda, Kappa, and Medallion architecture patterns for data pipelines?

Lambda, Kappa, and Medallion patterns are data pipeline architecture styles guiding ETL and ELT design. They provide blueprints for batch and streaming processing, mapping data flows to bronze, silver, and gold layers for scalable modernization.

How do I design idempotent upserts and data quality contracts for ETL pipelines?

Design idempotent upserts and data quality contracts by defining strict data reliability rules within your ETL pipelines. This approach ensures repeatable executions without duplicating records and enforces schema expectations for robust data governance.

When do I need a Medallion architecture with bronze, silver, and gold layers?

You need a Medallion architecture with bronze, silver, and gold layers when designing a multi-region data lake. This layered pattern organizes data pipeline refinement from raw ingestion to curated analytics, ensuring clear data lineage and quality.

What is the best way to implement event-driven orchestration for streaming data pipelines?

The best way to implement event-driven orchestration for streaming data pipelines is by applying the Kappa architecture pattern. It guides continuous processing design decisions, ensuring reliable data flow and observability across your orchestration layers.

How does data lineage reasoning improve ETL pipeline reliability?

Data lineage reasoning improves ETL pipeline reliability by tracking data transformations across orchestration layers. It provides end-to-end visibility into data origins and movements, enabling practical governance and faster troubleshooting of pipeline errors.

Can I use these pipeline architecture patterns for both batch and streaming processing?

Yes, you can use these pipeline architecture patterns for both batch and streaming processing. The guidance covers Lambda and Kappa styles to help you design ETL and ELT pipelines that handle diverse data engineering project requirements.