Truncate Appended Domo Workbench Dataset
zreimold
Member
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.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive