What is the best and most efficient practice to export table and column listings for databases that I have scanned in EDC?
I can select Column as my Asset Type in the first screen
followed by at least one attribute.
I am prompted for a file name and location next.
After the file is downloaded, I opened the CSV file, and parsed the Id column.
In general, it seemed to follow a format such as RESOURCE://DATABASE/SCHEMA/TABLE/COLUMN.
I am aware of the Rest API, but I could not find one for exporting table and column listings. Furthermore, I could not find an id (numeric) for the higher level database object (my schema or database). I have a name but not a number. The challenge with the API is that I need a custom Java or Python program to parse the API output, so I am back to the same issue as with the CSV file.
Is there a cleaner way to extracting table and column listings out of EDC?
The user-friendly way for exporting the table and column details would be from the catalog UI