Data dictionary

[TechSolomon]

Column Description (Generated Example)

import json
import csv

with open('metadata.json') as f:
    data = json.load(f)

rows = []
for table in data['tables']:
    for col in table['columns']:
        rows.append({
            'Table': table['name'],
            'Column': col['name'],
            'Type': col['type'],
            'Nullable': col['isNullable'],
            'Unique': col['isUnique'],
            'Default': col['defaultValue'],
            'Field Type': col['meta'].get('fieldType', ''),
            'Description': col['meta'].get('description', '')
        })

with open('data_dictionary.csv', 'w', newline='') as csvfile:
    writer = csv.DictWriter(csvfile, fieldnames=rows[0].keys())
    writer.writeheader()
    writer.writerows(rows)