How to erase the contents of an existing dataset without deleting it?
I'm quite new to Domo so my apologies in advance if I've missed something obvious...
I'm using the Streaming API to create several datasets and pushing data to them from our internal systems. All these datasets use the "APPEND" option as we will incrementally push transactions and other data to these datasets over time.
Based on these datasets, I'm now creating derived datasets and cards to display the data.
So far so good. Except that I discovered that I needed to delete the existing contents of a dataset and re-upload it due to a bug in my code. There doesn't appear to be any way of erasing the contents of an existing dataset -- the only way I could find to do that is to delete the entire dataset, which also appears to delete any cards based on the dataset that gets deleted. Yikes -- now I've just lost a bunch of work I've done setting up cards based on my dataset.
I tried creating a dataflow to erase the existing dataset, but dataflows require you to choose a new unique output dataset, not an existing one.
How can I erase the contents of a dataset without deleting it?
One idea I had was possibly to update the schema to change it from "APPEND" to "REPLACE", upload an empty set of data, and then change it back to "APPEND" again. But I'm not sure if Domo's APIs let us change how data gets uploaded to the dataset.
Any other suggestions or clues would be most welcome!
Thank you,
- Erik.
Comments
-
Hi,
Is anyone able to help out with this request?
Thanks,0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 180 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive