Deleting records from a dataset using MySQL
Hi dojo -
I have a Box connector dataset that has duplicates from a run happening multiple times. I've written a simple SQL statement to delete the records, but am not seeing the results.
Since I'm not generating an output dataset, I can't save the dataflow, yet when Run/Apply, the rows I'm trying to delete are still there.
Any thoughts?
Thank you!
amy
Best Answer
-
Hey Amy!
The way dataflow works is that it creates a temporary environment and loads your input tables and any transforms you create in the dataflow into temporary tables that only exist in that environment.
This means that any changes you make to the input datasets or other transforms only happen at the temporary table level.
In your case, in order to remove your duplicates, you'll want to run those SQL statements and then output the result.
As an example you could run your delete statements and then output a Select * from the table you deleted your records from.
Let me know if you have additional questions!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2
Answers
-
Hey Amy!
The way dataflow works is that it creates a temporary environment and loads your input tables and any transforms you create in the dataflow into temporary tables that only exist in that environment.
This means that any changes you make to the input datasets or other transforms only happen at the temporary table level.
In your case, in order to remove your duplicates, you'll want to run those SQL statements and then output the result.
As an example you could run your delete statements and then output a Select * from the table you deleted your records from.
Let me know if you have additional questions!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
aha!
makes sense - thank you, xervamason!
amy
0 -
Hello,
I had a similar question. Can I delete records from my input dataset, and then use the same dataset (from which I have deleted records) as output.
In other words, can I change my input dataset through mysql commands (or even ETL)?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive