Skip to main content
michael_sweeney
Helper ⭐️
September 14, 2016
New Idea

Customer would like to delete data in the MDA using Rules Engine.

  • September 14, 2016
  • 20 replies
  • 466 views
Wanting to delete older data weekly before inserting new data.

    20 replies

    sundar
    Expert ⭐️
    September 15, 2016
    Thanks Michael. Delete is a risky option on a system like Rules, do you think of a archive before the delete?
    brijesh
    Contributor ⭐️⭐️⭐️
    December 27, 2016
    Sundar - We also have some similar requirement where we wanted to purge or archive data if not needed. Is there automated way of archive or purge ?
    sundar
    Expert ⭐️
    December 28, 2016
    We are coming up with a feature to Export data to Your S3 bucket / Gainsight's S3 bucket, which can help in this regard.
    johnny_burtchaell
    Helper ⭐️
    March 1, 2017
    Is there a way to delete Data within the MDA manually? I have a field i created, but want to delete the data so that i can edit the Data Type from Percentage to Number.
    jeffrey_coleman
    Helper ⭐️
    April 21, 2017
    I think Delete should be used with caution, but should also be available. I'm creating a large number of rows for a daily calculation only to move the value back to the original table. Not being able to purge that table is a waste of space and adds some complexity to my rules. So I vote for "rule builder beware!"
    jeffrey_coleman
    Helper ⭐️
    April 21, 2017
    And -- Johnny -- if you haven't seen this already, go to the Custom Object's Data page, filter to the right data sent, and then you can delete those records. (Or all records.)
    daniel_oberes_b2e3e0
    Contributor ⭐️⭐️⭐️⭐️
    September 18, 2017
    Hi All,

    Understand the risk. Can we get clarity on archive solution?

    For now, manual deletion is fine but we are using MDA for automated processes and only want to keep the data we need for our daily CoPilot jobs. 

    This table can get huge and we don't want to store all of that data in MDA is we don't have to.
    brijesh
    Contributor ⭐️⭐️⭐️
    October 24, 2017
    API/automated method is good to have as we run into these situation all time
    samantha_braastad
    Contributor ⭐️⭐️⭐️⭐️⭐️
    October 11, 2018
    This is becoming a requirement for us as well. We have data loading currently on a daily basis but only need to keep the daily analysis for 12-14m. After that, we would like to aggregate the data to monthly in order to reduce the size of the file and then delete the daily records. Currently, we do not have a way to do this in mass. Any suggestions?
    keith_mattes
    Helper ⭐️⭐️
    March 13, 2019
    I 100% vote this up with perhaps a large/loud disclaimer and mandatory test run and export/archive option? We have accrued over 361M records in one object and the optimal object size is 10M and we anticipate expanding our customer base rapidly. Please help!!!!

    @jeffrey_boyer / @chris_mudd / @shibani_mehta Attempting to reinvigorate this need/requirement, please assist?

    Sr. Customer Success Operations Analyst/Gainsight Admin/Data Nerd