Define practical data quality checks and thresholds for a critical table.
#data-quality
#testing
#great-expectations
#dbt
Prompt
Create a data quality test suite for this dataset.
Table / model: [name]
Grain: [one row per …]
Critical columns:
[List columns and business meaning]
Downstream consumers: [dashboards / ML / finance / ops]
Tooling: [dbt tests / Great Expectations / custom SQL]
For each check provide:
1. Check name and type (completeness, uniqueness, validity, freshness, consistency)
2. SQL or config snippet
3. Severity (warn / fail)
4. Suggested threshold or SLA
5. What to do when it fails
Customize
Fill Variables
Details
Model
GPT-4
Category
Data Engineering
Added On
Jun 6, 2025
Prompts are starting points. Review outputs before using them in production.