Robust Idempotent ETL Data Pipeline Design
This is a ready-made prompt from the Zayenha Prompt library in Programming & Tech, written for claude-sonnet-4-7. It has a main prompt to copy into the model, built-in quality guards, and a verification prompt to run in a second window to review the answer. The full text needs the Pro plan; the description is open to all.
Design a robust, safely re-runnable ETL pipeline with data quality, failure handling, and privacy, without inventing connectors or transform functions absent from the specified pipeline tools.
Your current plan: free
Building a data ingestion pipeline safely re-runnable after failure, enforcing data quality before loading to the warehouse, designing a pipeline compliant with personal-data privacy per PDPL.
Built-in quality guards
No fabricated connectors or transform functions undocumented in the pipeline tools
Validate incoming data and mask personal data per OWASP and PDPL
Cover contract, extraction, quality, load, failure, and privacy without truncation
Adherence to six-section structure, data contract table, and code example
Frequently asked questions
How do I use this prompt?
Copy the main prompt and paste it into claude-sonnet-4-7 or the model you use, replace what is in square brackets with your details, then run the verification prompt in a second window with the answer pasted in, and review it before relying on it.
Is this prompt free?
Its full text requires the Pro plan or higher. Free prompts you can copy at once without an account are on the ready-made Arabic prompts page.
Which model was this prompt written for?
It was written for claude-sonnet-4-7 and follows how that model works; you can run it on other models too, reviewing the result, since no single wording guarantees the best result on every model.