You can translate the question and the replies:

Query Lineage information

We are trying to find lineage information of a denodo view from external system. While searching I found the query command "DESC" which produces the queries used to create the view and much more related information. Are there any other cammands that we can use to get lineage information in more structured way?
Lineage
user
19-12-2016 12:59:31 -0500
code

3 Answers

From the advanced VQL Guide, 12.3.14: > 12.3.14 VIEW_DEPENDENCIES > Description > The stored procedure VIEW_DEPENDENCIES returns a list of the dependencies of one or more derived views (not base views). > This procedure allows you to obtain programmatically the same information that the Administration Tool displays in the “Tree view” dialog of a derived view. I think you need to be on Denodo 5.5 20151005 update. It isn't a true "Lineage" as much as it is a "show me the dependencies". A Denodo representative may have a better answer. Thanks~! Nathan
user
19-12-2016 14:07:30 -0500
PS: the "view_dependencies" stored procedure can probably be run via JDBC connection into Denodo. I haven't tested it yet.
user
19-12-2016 14:08:56 -0500
This helps! Thank you Nathan!
user
20-12-2016 11:10:43 -0500
You must sign in to add an answer. If you do not have an account, you can register here