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
OP5 years ago · EditedThank 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
·5 years ago · EditedDepending 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: