You can translate the question and the replies:

Retrieving Lineage of views

Hi Denodo team, I want to retrieve lineage of a view and its columns through query. Like if give a view name to query it should fetch its relative views.In similar way for its columns.Please help me with this.
21-10-2020 09:51:30 -0400

1 Answer

Hi, For your usecase, you could utilize [COLUMN_DEPENDENCIES]( predefined stored procedure which returns the list of data sources and views from which the value of a field is obtained. This helps you programmatically obtain the same information as the [Data Lineage]( option available in Virtual DataPort Administration Tool. Let's assume, if you want to retrieve the Data lineage for a derived view 'dv_orders' which is in the virtual database 'denodo_training', then you can execute a similar query mentioned below: ``` CALL COLUMN_DEPENDENCIES('denodo_training', 'dv_orders', null) (or) SELECT * FROM COLUMN_DEPENDENCIES() where input_view_database_name = 'denodo_training' and input_view_name = 'dv_orders' ``` I suggest you to refer to the aformentioned document link and also similar Community Q&A [How to get denodo data lineage through view_dependencies()]( for more information. Hope this helps!
Denodo Team
22-10-2020 02:11:03 -0400
You must sign in to add an answer. If you do not have an account, you can register here