Hi Domo Community,
I’m currently working with a dataset (via MongoDB Connector) that operates on a 12-month rolling window, where data older than 12 months is deleted on the 1st of each month. Long story short, I cannot change this configuration. But, I would like to retain some of this older data using partitioning before it gets deleted.
Would partitioning be the solution for this? Could anyone advise on the best approach to set up partitioning in Domo to achieve this? Specifically, I’m looking to keep data from certain months beyond the 12-month window while still allowing the rolling window to function as intended for the rest of the data.
Any guidance or step-by-step instructions would be greatly appreciated!
Thanks in advance for your help