Customer would like to delete data in the MDA using Rules Engine.
None
Wanting to delete older data weekly before inserting new data.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
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.
@jeffrey_boyer / @chris_mudd / @shibani_mehta Attempting to reinvigorate this need/requirement, please assist?
@dan_ahrens
https://support.gainsight.com/View_More_Categories/GainsightNXT/02Data_Management/02Managing_Data_In_Gainsight/01Gainsight_Data_Management#Deleting_Data_from_a_Custom_Object
I recorded a quick demo of this below. Just apply the filter to show the records that you want to purge and select the delete option. Takes about 30 seconds.
We realize this is not as simple as doing this via rules engine, but wanted to make sure that everyone knew that purging old records is supported today with just a little bit of manual effort.
In cases where you have huge quantities of records (hundreds of thousands or even millions) you can drop a support ticket to Gainsight Support and our tech ops team can help with those large quantities. @keith_mattes
Can you explain a bit more as to what missing functionality you'd be looking to achieve that a test run function would give you?
Example:
XXXX number of records will be deleted that were used in the following items:
*Report Name
*Dashboard Name
*CTA Name
BONUS ADMIN FEATURE: The ability to place records in a temporary state aka "soft delete" (or table) to "test" impact" with ability to "revert" if change/impact too great or undesired.
SUPER BONUS FEATURE: Part of this Archive feature enables the automatic creation of an archive roll-up table with the multi-select option for tables for weekly/monthly/yearly rollup of the data
Long story short, “upsert” is taking too long that forces my data load rules to get aborted. Have tried different directions to get around it, but ultimately this functionality would solve it and be a huge win! Either the Rules Engine or somehow deleting in mass via the API, we would love this functionality!
This would be very useful in some of my use cases as well.
A sample is when some data is related to SFDC and we delete from SF it should be deleted on MDA as well... But in an automatic way or by rules.
The use case we have for deleting of records is related to data privacy.
We hold some data (including PII) that belongs to our customers and they can withdraw consent at any time, after which we need to delete the data. The consent status for all customers is included within an S3 file we get daily, and so based off that we would then want to delete relevant data for those where consent = false. Also churned customers should have the data deleted within 90 days.
Currently it looks like we will need to anonymise the data instead, as deleting isn’t possible?
Just wanted to call out that Administration / Data Management does support deletion of records in bulk.
https://support.gainsight.com/View_More_Categories/GainsightNXT/02Data_Management/02Managing_Data_In_Gainsight/01Gainsight_Data_Management#Deleting_Data_from_a_Custom_Object
I recorded a quick demo of this below. Just apply the filter to show the records that you want to purge and select the delete option. Takes about 30 seconds.
We realize this is not as simple as doing this via rules engine, but wanted to make sure that everyone knew that purging old records is supported today with just a little bit of manual effort.
In cases where you have huge quantities of records (hundreds of thousands or even millions) you can drop a support ticket to Gainsight Support and our tech ops team can help with those large quantities. @keith_mattes
+1.
we have an option to delete the records from Data Management.