Design practical checks for data freshness, schema drift, and bad records. Replace the bracketed details with your own project information before use.

Copy this prompt

Design a quality gate for a pipeline that moves [source] to [destination] every [frequency]. Known schema: [fields]. Define checks for missing values, duplicate keys, invalid ranges, timestamp freshness, unexpected categories, schema changes, and volume anomalies. For each check specify threshold, severity, response, and how to avoid false alarms. Show a sample validation report and a recovery decision tree. State which checks require historical baselines. Do not invent production metrics or silently discard failed rows.

How to use it

Supply a small anonymized sample and real tolerances to tune thresholds. Review the output against your source material, then revise one requirement at a time. Explore more free examples in the AI Craft Pad prompt library.