Save AS ETL not functioning properly?
Hi, I am running into a weird issue.
In most cases you can use "Save As" to make adjusted copies of a card or dashboard without changing the original. However, that's not working for ETLs for me.
Instead of having a separate ETL, it keeps sending me back into the original. I'm just trying to apply the same name mapping as the original, but to a slightly different dataset. If I copy and paste the tiles into a new ETL, I would still have to re-enter all of the mappings.
Does anyone have an idea on how I can expedite setting up an ETL when I already have the logic and mappings in another?
Thank you!
Best Answer
-
@HowDoIDomo It usually works for me if I just the "Create Copy" option
0
Answers
-
@HowDoIDomo It usually works for me if I just the "Create Copy" option
0 -
@MichelleH Thank you! I'll try that. I'm realizing now that If I change the input file, I lose all of data entered into any subsequent tiles. is there any way to change the sourcefile without losing my previous work?
0 -
@HowDoIDomo Are there specific tiles where you're losing work? It may help to see a screenshot of what you're seeing. Also, when you change the input file are you adding an entire new Input tile or just changing the dataset on the same tile?
0 -
Domo datasets have a unique identifier behind them. When you view a dataset, you will see the identifier in the URL. When you make a copy of an ETL, you are normally setting up new datasets rather than pointing back at the original source of the tile. This pertains specifically to output tiles vs inputs.
Output tiles default to replacing the dataset rather than appending the dataset.- Unique Identifier for Datasets:
- Domo datasets have a unique identifier visible in the URL. This identifier is what ties various elements (tiles, dashboards, etc.) to the specific dataset.
- Copying ETLs and Dataset Disconnect:
- When you copy an ETL, it usually creates new datasets for the output tiles rather than pointing back to the original dataset. This is crucial when you're duplicating ETLs for a new use case, as the new datasets act independently of the originals.
- Output Tiles vs. Input Tiles:
- Output tiles specifically create or update datasets in Domo. By default, these output tiles are set to replace the dataset on each run, not append to it. This default behavior is important to highlight because it ensures the dataset reflects the current state of the ETL logic without accumulating historical data unless specifically configured to append.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 - Unique Identifier for Datasets:
-
@HowDoIDomo I just discovered Save as in ETL today. Using Save As will make a new flow but its still connected the the same output dataset. This makes the dataset ID no longer unique. Not its one dataset being powered by 2 flows (or more) and now either flow can make edits to that dataset.
To get a complete new copy where you just want to copy logic and have it in a new dataset you will need to do what @MichelleH mentioned and use Create a Copy.
I have not been able to find any documentation about how Save As works but just know it will create new flows that all power the same output dataset, hence why it keeps bringing you back to the same one, because it is the same one.
**If this answer solved your problem be sure to like it and accept it as a solution!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 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
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 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
- 108 Community Announcements
- 4.8K Archive