You can translate the question and the replies:

VQL for Retrieving Used By information for View

Is it possible to retrieve the Used By information (which is available in the VDP Admin Tool) for a view via VQL or some other programmatic method?
user
13-07-2021 10:38:54 -0400
code

2 Answers

Hi, Denodo Platform provides stored procedures to deal with this. On giving the command, LIST PROCEDURES, it will list Denodo-provided stored procedures as well as custom stored procedures. The stored procedure VIEW DEPENDENCIES returns the lineage of a view ( i.e. list of views and data sources from which a view was built on). On your VQL shell, give the command, `SELECT * FROM VIEW_DEPENDENCIES() WHERE input_view_database_name = <database_name> AND input_view_name =<view_name>;` Run this command, once the <database_name> and <view_name> fields are appropriately replaced. For more information, please refer [here.](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/view_dependencies) Hope this helps!
Denodo Team
13-07-2021 15:53:09 -0400
code
Perfect...Thanks!
user
13-07-2021 16:22:21 -0400
You must sign in to add an answer. If you do not have an account, you can register here