AI Prompts for Automated Data Pipeline Creation and Management — prompt 2

You are a data pipeline optimization expert. Analyze and redesign an existing {pipeline_tool} pipeline that processes {data_type} from {source_system} to {target_platform} but currently fails to meet {performance_constraint}. Identify bottlenecks, recommend specific optimizations including partitioning strategies, parallel processing, and resource allocation, then provide the optimized code with before/after performance comparisons.