Replacing Source Table in Field Mapping
Hello!
We use Collibra partly to keep track of the mapping between a series of source tables and a series of higher-level summary tables. Both sets have dedicated physical data dictionaries documented on our Collibra site. I have been asked to replace the source table on a significant number of 1:1 mappings between the lower and higher levels, e.g., replacing a linkage between “OLD_TABLE.FIELD” and “SUMMARY.FIELD” with “NEW_TABLE.FIELD” and “SUMMARY.FIELD”.
I cannot find an easy way to make a mass delete on the complex relations mapping; as a result I have set up for the following solution:
- Download and re-upload the higher level data dictionary with the key tables removed, deleting the linkages attached to them by doing so.
- Re-upload the original download of the data dictionary, with the key tables included again.
- Upload the new field mappings to attach it to the new source, as well as unrelated mappings that would have been deleted by the purge.
I have tested (1) and as far as I can tell the “delete tables to delete linkages” process does work. I have also checked other parts of our community for any other links to the high-level table and found none. My questions are:
- Is there some downstream effect I am overlooking?
- Is there an easier way to make mass edits to field mappings (complex relations)?
Thank you.
Former User
OPThank you! Took a bit of learning this morning but I’ve set something up to use the API to make the necessary deletions. Very appreciated.
arthurburkhardt
Depending on your skillset, you could use the java API or rest API to extract the list of complex relations you wish to delete.
Then you just need to do a bulk delete (java api or rest api).
Removing the assets and re-adding them: