You can translate the question and the replies:

How to get denodo data lineage through view_dependencies()

Hi all, We are trying to recreate denodo data lineage in one of our vizualization system. If I am querying the [VIEW DEPENDENCIES](https://community.denodo.com/docs/html/browse/latest/vdp/vql/storedprocedures/predefinedstoredprocedures/viewdependencies#view-dependencies) It is giving data in a cluttered format which is very tough to recreate the lineage. Let's say I am querying dependencies of a business view which has Integrated view -> 4 Integrated views -> respective base views. I am getting first base view is directly linked to the last datasource with a depth 1. I am trying to get a solid solution for this. Please help me with this. Thank you in advance.
user
18-05-2020 05:55:11 -0400

3 Answers

Hi, I would use [COLUMN_DEPENDENCIES](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/column_dependencies) stored procedure to Replicate Data Lineage programmatically. To make the output to be displayed in the order of graphical representation, I would use ORDER BY clause to order my result based on view_identifier and VQL looks like below. `SELECT * FROM COLUMN_DEPENDENCIES() where input_view_database_name ='xxxx' and input_view_name = 'xxxx' order by view_identifier;` Hope this helps!
Denodo Team
19-05-2020 07:17:28 -0400
Hi Team, Thank you for the response, but I am still getting my business view is directly linked to a datasource that is at the 10th level. I am looking a better way to get a 1:1 relation with each other. Any one please suggest a better way to do this. Thank you so much.
user
28-05-2020 13:40:53 -0400
Hi, When I check the data lineage for one of my business views and its datasource at 10th level. The given query displays the result perfectly as the same in the order of graphical representation. If you are a user with valid support access then you can raise a support case in the [Denodo Support Site](https://support.denodo.com/) so they can help you out with the troubleshooting steps. Hope this helps!
Denodo Team
04-06-2020 07:21:43 -0400
You must sign in to add an answer. If you do not have an account, you can register here