I have several flat file data sources (CSVs) that are extracted, transformed and loaded into relational tables. At some point in time, when I look at a table, I often have a hard time figuring out where some of the fields in that table actually came from, since multiple flat files would have contributed to a single table.
I am looking for a visualization tool that can help me map fields in my CSVs to fields in my databases so that I can trace back and forth when required.
The tool also needs to have a search functionality which lets me search for a field by name to help me identify which tables and/or CSVs have that field.
I found Amundsen to be promising but it does not support requirement 1.