replace a Dataset within SQL workflow and within transforms
I think could be great to be able to replace a Dataset in a SQL workflow with a new one, not only adding the new data set but as well replacing Dataset name within all transforms. Maybe adding an option to Edit, Delete (image 1) (Replacing if dataset name on sql statement is "name").
Let's say, I have a new data set (using image sample) "EmploymentCycleUpgraded" and then should be replaced with "EmploymentCycleUpgraded_v2".
Not sure if possible or is already available.
This is, by nature, available on Magic ETL (image 2)
Comments
-
it is possible. you'll notice that in your screenshot the name of the dataset is aliasedfrom EmploymentCycleUpgraded to employmentcycleupgraded.
if you wanted to swap in a new dataset to your ETL, just add it in and then change the alias.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
That's how I do it, too. It's annoying to not be able to just click on it and change the dataset, but I can see why they did it that way. A new dataset would likely automatically update the alias and break everything. The solution @jaeW_at_Onyx suggested works perfectly every time, as long as the new dataset has the right structure.
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive