Truncate Appended Domo Workbench Dataset

We have some datasets on our Domo Workbench setup as Appends. They have grown very large over time as they take a snapshot of the data daily. The datasets are still used but we no longer need the complete history. We would like to do something like keep the last 2 years or maybe keep one reading per month or something along those lines. We could use a recursive dataflow to trim down the data and then change the original dataset from an append to a replace. However, we would then have to switch over all existing cards, dataflows, beast modes, etc. It would be helpful to be able to build out the master dataset in the workbench only without needing to add an ETL step.

Tagged:
1
1 votes