question Re: How do I delete an Atlas tag which are associated with entities those are already deleted? in Support Questions

question Re: How do I delete an Atlas tag which are associated with entities those are already deleted? in Support Questions https://community.cloudera.com/t5/Support-Questions/How-do-I-delete-an-Atlas-tag-which-are-associated-with/m-p/286143#M212239 You need to find the parent that has the association and delete the references.  Example: I have a hive table with a column that is SSN and it had two tags associated to it. Even after the association was removed it still contains the history. When you delete you get an error message. Given type {TagName} has references.<img src="https://community.cloudera.com/t5/image/serverpage/image-id/25794i1D34962457AF5C5B/image-size/large?v=v2&px=999" role="button" title="Picture1.png" alt="Picture1.png" /> In this case I know I have a hive_column that had this reference and I need to find the proper GUID in order to delete this reference and get this test setup out of my UI.  First I do a search for these items above in the Atlas UI. <img src="https://community.cloudera.com/t5/image/serverpage/image-id/25795i7BC810C4A2A14CD6/image-size/large?v=v2&px=999" role="button" title="Picture2.png" alt="Picture2.png" />Check the option for Show historical entities in the event yours has been deleted.<img src="https://community.cloudera.com/t5/image/serverpage/image-id/25796iDE91224ED770BA8B/image-size/large?v=v2&px=999" role="button" title="Picture3.png" alt="Picture3.png" />The information is displayed in the UI and this is the one I am after.<img src="https://community.cloudera.com/t5/image/serverpage/image-id/25797i08546984A0BCDAF6/image-size/large?v=v2&px=999" role="button" title="Picture4.png" alt="Picture4.png" />Next I will use the developer tools in chrome and generally I clear out any of the history to help reduce any confusion as to what I am looking for. <img src="https://community.cloudera.com/t5/image/serverpage/image-id/25798iC7AC23AE02E92559/image-size/large?v=v2&px=999" role="button" title="Picture5.png" alt="Picture5.png" />Next click on ssn or your entity that was associated to a classification. <img src="https://community.cloudera.com/t5/image/serverpage/image-id/25799i7C43ABD312527CED/image-size/large?v=v2&px=999" role="button" title="Picture6.png" alt="Picture6.png" />The url is in the panel for the get request, and the GUID in the URL is what you are after.<img src="https://community.cloudera.com/t5/image/serverpage/image-id/25800i782DF15562EA2866/image-size/large?v=v2&px=999" role="button" title="Picture7.png" alt="Picture7.png" /> Delete the classification from the GUID.curl -iv -u tkreutzer \-X DELETE  <A href="http://yourhost:21000/api/atlas/v2/entity/guid/ec8a34c7-db67-41b8-a14c-32a19d2166bf/classification/SSNHR" target="_self">http://yourhost:21000/api/atlas/v2/entity/guid/ec8a34c7-db67-41b8-a14c-32a19d2166bf/classification/SSNHR</A> Now you can delete the Classification from the UI, barring there are no other associations. If so, rinse and repeat for each hive column.  I will probably try to figure out a way to do this via REST with Python later in a way that finds all associated GUID's for us.  Hope this help...Cheers      Sat, 21 Dec 2019 14:33:43 GMT thomaskreutzer 2019-12-21T14:33:43Z