Acerca de
This skill provides comprehensive patterns for architecting robust Python-based data pipelines, focusing on SQLAlchemy 2.0 implementations and modern data warehousing principles like Kimball star schemas and medallion layers. It guides developers through implementing complex ETL/ELT workflows, managing schema evolution via JSONB, and ensuring data integrity with Pydantic validation. By establishing a clear three-layer separation between source systems, database schemas, and application logic, it enables the creation of maintainable, scalable, and high-performance data infrastructure on PostgreSQL.
