Is there a way to auto-delete the data after a certain period of time?
Answers
-
Hi @yli_2596, I am assuming you are referring to the data in the underlying architecture, and for that, there's currently not an easy way to delete data. A few options you can explore are:
- Creating a dataflow to input your dataset, filter out the rows you don't want and then write it out to another dataset,
- Temporarily using the replace method and then go back to your append method (using the ETL tiles),
- Requesting certain rows to be deleted via Domo Support
13 -
In theory you could utilize a webform or some other dataset with a dataset ID column and another column which would contain the number of days you wish to keep data in your dataset for. You can then utilize a Recursive Magic ETL dataflow to then filter the data down to the values that are within the number you specified and write it back out to your original dataset.
Here's some more information about recursive dataflows: https://domohelp.domo.com/hc/en-us/articles/360057087393-Creating-a-Recursive-Snapshot-DataFlow-in-the-New-Magic-ETL
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 46 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive