Dataset Schema & Templating

Spreadsheet for mapping HDR data to databases:

Estimate ~35% of the dataset management cant be templates.

The templating will mostly benefit the data controller/access/use cases aspects of the data management

For managing the technical metadata, it may make sense to add an extraction step that gets the descriptions for the extracted columns and update the metadata this way (could also be ran manually).

From looking at the sql extraxction query, we should be able to get the technical details of each column using something like