Reltio Connect

 View Only
  • 1.  Hard Delete an Attribute all it's values permanently

    Reltio Partner
    Posted 02-09-2022 00:05
    Hello,

    We are planning to drop few attributes and all it's values  in our Data Model Permanently and want to ensure they are deleted in Cassandra database as well.

    Wondering just by deleting attribute in L3 Configuration gives expected results.  Please suggest the best option for the same.


    ------------------------------
    Srujan kumar
    Principal Data Engineer,
    KPI Partners, Bangalore.
    ------------------------------


  • 2.  RE: Hard Delete an Attribute all it's values permanently

    Posted 02-10-2022 09:27
    Hi Srujan,

    My recommendation would be to remove all of the data values first from your tenant, then delete the attribute from the L3.  If you just delete the attribute from the L3, you will not be removing the actual data. 



    Thanks!

    ------------------------------
    Pete Cory
    Senior Solution Consultant
    Reltio
    ------------------------------



  • 3.  RE: Hard Delete an Attribute all it's values permanently

    Reltio Employee
    Posted 02-10-2022 10:32
    I agree with Pete.  We have played with this as a team, and the data is not automatically deleted if you change the L3.  You can see the API from the UI on the sources perpective.  Edit an attribute and then click the trash can to delete.  It looks like:

    DELETE: https://gus-sales.reltio.com/reltio/api/TenantId/entities/EntityId/attributes/BirthCity/4IsTEfeED?crosswalkValue=1LScxYwk.  You can get the id's from the GET on the entity.

    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------



  • 4.  RE: Hard Delete an Attribute all it's values permanently

    Reltio Partner
    Posted 02-11-2022 09:23
    Hello,
    Thanks for the suggestion. 
    We have a data volume of 2Million records and deleting the attribute values by URI will be tedious  though we designed a JAVA frame work. 
    And also we may have to delete Nested attributes as well and their  volume more than 10 Million. (i.e. 4 to 5 Nested attribute values  per Entity)

    Please suggest the best approach to achieve it with the best performance.

    Thanks in advance.


    ------------------------------
    Srujan
    Principal Data Engineer,
    KPI Partners, Bangalore
    ------------------------------



  • 5.  RE: Hard Delete an Attribute all it's values permanently

    Reltio Employee
    Posted 02-11-2022 11:08
    I am not sure what API is used, but it appears that using the bulk update feature, you can select the attribute and then 'clear attribute' function seems to actually remove the value.  Please test it on your end.....

    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------



  • 6.  RE: Hard Delete an Attribute all it's values permanently

    Founding Member
    Posted 08-09-2022 14:45
    bulk update for clear attribute only puts an ignore button on that attribute it does not actually clear/delete  the attribute.

    ------------------------------
    Angela Wawrzaszek
    Manager, MDM governance and Application Enablement
    ------------------------------



  • 7.  RE: Hard Delete an Attribute all it's values permanently

    Reltio Employee
    Posted 08-09-2022 18:07
    Hi!

    Angela, you got me thinking (always dangerous), so I went and tested it.  In my tenant with the new UI enabled, doing a bulk update on one or several records > Continue > Update Profiles > Selecting the attribute and 'Clear Attribute' as the operation seems to have actually removed it.  I say this because i don't see the attribute in the sources screen.  Additionally, I did a 'GET' of the entity via the API and the deleted attribute is not there....  It worked the same way when I selected 'Find and Remove' as the operation with the value I was trying to delete.

    What's weird is I thought you were correct about the bulk update.

    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------



  • 8.  RE: Hard Delete an Attribute all it's values permanently

    Founding Member
    Posted 08-10-2022 09:40

    Thanks for the information,  I did switch my preferences to the new UI and I still get only the ignore on the attributes I selected to remove.

     

    I may reach out to Reltio on this as I would like to use this feature if possible!

     

     

    Angela Wawrzaszek

    Manager MDM Gov & App Enablement  / IT

    4341 State St. Rd. Skaneateles Falls, NY 13153 / US

    T +1.315.291.3565  

    Angela.Wawrzaszek@Hillrom.com

     

          

    Hillrom is now a part of Baxter

     

     



    CONFIDENTIAL NOTICE: If you are not the intended recipient of this message, you are not authorized to intercept, read, print, retain, copy, forward, or disseminate this communication. This communication may contain information that is proprietary, attorney/client privileged, attorney work product, confidential or otherwise legally exempt from disclosure. If you have received this message in error, please notify the sender immediately either by phone or by return e-mail, and destroy all copies of this message, electronic, paper, or otherwise.