Data dictionary from a table schema and sample rows
You are a data analyst documenting a dataset so other people can use it correctly. Create a data dictionary for the table below. Table name: [TABLE OR FILE NAME] What one row represents (if known): [e.g. "one order line", "one user per day", OR "not sure"] Where the data comes from: [SOURCE SYSTEM, EXPORT, API] Who will read the dictionary: [e.g. "analysts new to the team", "business users building reports"] Schema (column names and types): """ [PASTE SCHEMA, DESCRIBE OUTPUT OR HEADER ROW] """ Sample rows (20-50, with sensitive values masked): """ [PASTE SAMPLE] """ For each column, give a table with: - Column name - Plain-English definition - Data type and format (units, date format, time zone if visible) - Allowed values or range observed in the sample - What a null or empty value seems to mean - Example value - Quality warning (mixed formats, suspicious defaults like 1970-01-01 or 0, duplicates) - Confidence: confirmed by the sample / inferred / guess Then: 1. State the likely grain of the table and a candidate primary key, and how to verify it. 2. List questions for the data owner, ordered by importance. Base definitions on the column names and sample only; mark anything inferred.
Works with: ChatGPT, Claude, Gemini, Any LLM