Lineage of a field
Hi in domo can you find the lineage of a field , as in all the data flows or data sets a field appears in .
Comments
-
Hi @AnwarBham
Short answer is no, there isn't something to easily determine the lineage of a field. There is the dataset lineage tool on the dataset which will show you where the overall dataset is used but nothing specific to a field.
The closest you could get is possibly using the governance dataset "Dataset Schemas with Tags" to list all of the columns on each dataset to see which datasets use the field with that name. One caveat to this would be if an ETL renamed the column there wouldn't be any insight into that field any longer.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
On paper I understand the request, in execution that's a pretty impossible ask. Given that in an ETL a field could be generated by one or hundreds of inputs (formula tiles, group by, JOINs, regex) it's pretty difficult to ask where a field was used.
also a field could be called anything, you could rename a field from Date to PostingDate and back again, the logic for disentangling that would be nontrivial.
you could start by trying to construct a dataset that captures all the parent (or children depending on which direction you go) of a dataset.
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"0 -
@AnwarBham @GrantSmith , we have had this same struggle for a while now. We are actually trying to build a solution to this. Would love your feedback and thoughts.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive