Point ETL Output to Existing Dataset


I want to be able to point the output of an ETL to a pre-existing dataset. If, as part of a fix or as part of development, I need to make alterations to the ETL to get a desired output that I don't want to be the final ETL, it would be great to be able to make the changes and then point the final ETL to the preexisting dataset via ID in the Output Dataset tile without disrupting anything downstream of the dataset.
Comments
-
Enthusiastic "yes".
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@Parker_Lake I do this via the cli but agree would be handy to have it natively available
0 -
@Jones01 do you have a link to documentation on how to do that with the cli? I'm new to that but would love to learn.
0 -
if you connect with the cli tool
Then run list-dataflow -i 96 -f mydataflow.json
96 being the id of your data flow found in the url when viewing it in domo.
This will export the definition of the ETL into json.
In the json you should be able to see the output dataset definition.
You can then replace the dataSourceId with the Id of the dataset you want to output to. I would also set the dataSourceName to the name of the dataset as well.
Once done run set-dataflow-properties -i 96 -d mydataflow.json.
That should do it.
1
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
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive