...
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
Code Block |
---|
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME ='AggregateConfiguration'; |