Data Pipeline Quality Checks
Design quality checks, alerts, and backfills for data pipelines.

Prompt
# Role You are a data platform engineer familiar with freshness, completeness, uniqueness, and lineage monitoring. # Task Design quality checks for the data pipeline below. # Inputs Ask me for: background, goal, audience, existing assets, constraints, success criteria, output language, and channel. If data, competitors, screenshot descriptions, or past examples are provided, prioritize those facts and do not invent missing details. # Output Format 1. Data contract 2. Quality rules 3. Anomaly alerts 4. Backfill strategy 5. Lineage impact 6. Validation SQL # Quality Bar 1. Separate latency from correctness errors 2. Rules should be automatable 3. Explain false-positive handling # Avoid Do not give generic advice. Do not use unverifiable hype. Do not pad with irrelevant completeness. For business, medical, financial, legal, or security risks, state assumptions and boundaries. # Verification Control Provide a reusable checklist and explain which missing inputs would significantly change the result. # Process First decide whether the information is sufficient. If not, ask up to five clarifying questions. If yes, produce the actionable version directly. End with a concise copy-ready version.
Curated by the editorial team · Updated 06/28/2026 · Model: GPT-5
Usage guide
How to use this prompt
This template is designed for development tasks. Replace the sample details with real constraints before running it in GPT-5.
- Step 1
State the stack, runtime, inputs, outputs, and existing constraints.
- Step 2
Ask for the approach and risks before requesting the smallest verifiable change.
- Step 3
Run tests, type checks, and critical scenarios locally before merging.
Details to replace or add
Specific inputs produce more useful results. Do not submit passwords, private information, or confidential business data.
- Language, framework, and versions
- Current code and error output
- Expected inputs and outputs
- Compatibility and performance constraints
- Acceptance test cases
Output checklist
- The code runs on the specified versions
- Edge cases and errors are handled
- Existing project patterns are reused
- Tests cover critical behavior
- No new security or performance risk appears
Common adjustments
Provide the directory structure and interfaces when the answer drifts from the project.
Limit files and request staged changes when the proposal is too broad.
Ask for runnable test commands and expected output when verification is unclear.
This prompt separates Development, Testing, Data, DevOps requirements into context, constraints, and output format. Keep the objective fixed and revise only the conditions that failed before rewriting the whole template.
Related prompts
Explore more templates in Development.

Observability and SLO Review
Connect user journeys, service metrics, and alerts to reduce noise and improve incident response.

Multi-Tenant Data Isolation Review
Review tenant boundaries across queries, caches, jobs, and logs to prevent cross-tenant leakage.

Flaky Test Investigation
Use evidence to distinguish timing, shared state, environment, and real defects, then eliminate flaky failures.

Production Secret Rotation Runbook
Create a zero-downtime, auditable rotation process for database, API, or signing secrets.