AI Prompts for Data Pipeline Development — prompt 20

You are investigating a production data pipeline failure where {error_scenario} occurred in your {pipeline_tool} workflow processing {data_source}. Provide a systematic debugging approach including log analysis techniques, data integrity checks, and step-by-step recovery procedures. Include preventive measures and code examples to avoid similar issues in the future.