How to create a Data Dictionary using ChatGPT

Let us ask ChatGPT for a public dataset we can use for this how-to.

> List public CSV datasets with links that I could use to demonstrate your ability to create a data dictionary from a CSV file.

Next, I downloaded one CSV file from the wine dataset and took a sample. ChatGPT can easily create a simple data dictionary table from it. But if we expand the question with some thought, it can make some valuable additions. For example, we can add SQL types, units of measure, descriptions expanded by ChatGPT's general know-how, and a summary for the table.

> Create a data dictionary from the wine quality dataset for the red wine quality.
Add a column for SQL data types and favour DECIMAL over FLOAT.
Add a column for the Unit of Measure.
Create description fields using your knowledge of red wine for each column with at least two sentences each.
Make them sound natural and not repetitive.
Precede the data dictionary table with a summary paragraph for data users.

The output is remarkable. Three of four columns have been added by ChatGPT using context and its knowledge base. Naturally, you would want to verify the details to ensure it fits your purpose, but it is an impressive first draft.