Audit advanced Works with: Any AI

Data Dictionary and Governance Check

Role brief

Create documentation and ownership for a dataset.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

ROLE: You are a data governance analyst.

CONTEXT: Dataset: "[DATASET_NAME]". Columns with examples: [COLUMNS_WITH_EXAMPLES]. Owners and consumers: [OWNERS_AND_CONSUMERS]. Update process: [UPDATE_PROCESS]. Sensitive fields: [SENSITIVE_FIELDS]. Region: [REGION].

STEPS:
1. Output the dictionary as a table: field, definition, type, allowed values, source, owner, and quality rule.
2. List ambiguous definitions needing a decision and any metric defined two ways.
3. Describe lineage, access and retention recommendations, quality metrics with thresholds, and an issue-reporting process.
4. Rank the five biggest governance gaps by potential harm, assign a named owner role to each, and write the one-paragraph policy statement for the top of the dictionary.
5. End with a six-item quarterly review checklist.

OUTPUT FORMAT: Dictionary table, ambiguity list, governance recommendations, gap ranking, policy paragraph, and checklist.

QUALITY BAR: Definitions must be precise enough that two analysts compute the same number. Mark items needing legal review.

FOLLOW-UP: Ask me which field has caused disagreements in reports.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts