ETL Field Search Capability
It would be helpful in an ETL to be able to search for a field name and have the tiles that directly reference that field name be highlighted. Many times when supporting dataflow development we are looking for a field and we have to open every tile to see where that field is referenced - in join, in formulas, in filters, in group by, etc.
Comments
-
Bumping this, as I was just going to add the same exact commentary. The amount of time I am wasting trying to find a field and trace it back is relatively high. Column-level lineage within a given ETL would be immensely helpful.
2 -
Need the ability to search for Fields in ETL's that are Complex for troubleshooting purposes.
0 -
Great feedback. I'll make sure there's some visibility for this on the team. Thanks!
As a quick workaround, if you select multiple tiles (perhaps zoom out the tile canvas all the way to easily select all tiles), you'll get an option on the left to "Copy to Clipboard".
You can paste this into a text editor and do a search for the column name there. (Though the text is likely to all be on a single line. Using a JSON formatter would be helpful.) You should see the tile's name as an attribute to the JSON object in the list of actions there. Still not as helpful as an in-product feature, but, provided you're somewhat comfortable looking at JSON, it could at least help you find the tiles you need to look at somewhat more readily than clicking on every tile.
You could use this tool to format the JSON:
Or, if you prefer not to paste that into a third-party site, this JS snippet (use the browser dev tools "Console" or some other JS interpreter) can help:
console.log(JSON.stringify([paste clipboard contents here], null, 2));
0 -
Wanted to update you that we haven't lost sight of this and will be reviewing again soon.
Domo Product Manager for Data Transformation (MagicETL)
1 -
I was hoping to hear this feature got added at Domopalooza, but unfortunately not yet. We at Ticketmaster/Live Nation would love to have this. @Andrea Henderson, can you please add this soon?
0 -
@user031170 This is on my shortlist of things I'm reviewing with the team. I heard a lot of good feedback and requests for this feature at Domopalooza as well.
Domo Product Manager for Data Transformation (MagicETL)
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
- 60 App Studio
- 41 Variables
- 688 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 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