Data validation rules
Generates validation rules for a dataset — type, range, format, uniqueness, references.
Ready to drop into dbt tests, Great Expectations, or a custom checker.
The prompt
Copy this into ChatGPT, Claude, Gemini or any assistant you already use — then paste your own sample data (columns + a few rows) underneath it.
Generate validation rules. Table:
| Column | Type | Required | Range / format | Unique? | References | Notes |
Flag suspicious cases ("birth_year before 1900?", "amount = 0 unusual"). End with: "3 rules I'd enforce first".
Rules:
- Be specific to the data shown.
- Don't over-validate — rules that catch nothing are noise.Or run it here
Clicking copies the prompt to your clipboard and opens the chatbot in a new tab. Gemini doesn't accept URL params — paste manually with Ctrl/Cmd+V.
Related prompts
Breaks a top-line metric (e.g. ARR) into a tree of contributing inputs the team can act on.
Takes a vague stakeholder question and turns it into a precise, answerable analytical query.
Reads cohort data + surfaces retention shape, decay rate, and "is this curve flat enough?".
Given an unexpected metric change, lists 5 most-likely causes + the order to investigate.
Designs a 6-tile dashboard layout for a stakeholder, with each tile's metric + viz type.
Designs an A/B test — hypothesis, variants, primary metric, MDE, sample size, duration.
Browse the full free AI prompt library or see more data & analytics prompts.