You can translate the question and the replies:

Meta data information - SP´s get_source_table() and GET_SOURCE_COLUMNS()

Hi, I need extract all information about source tables and columns, but the the predefined SP´s get_source_table() and GET_SOURCE_COLUMNS() need input parameters (input_database_name and input_view_name). Which are Denodo tables where i find the meta data information? or how i extract all sources and columns names from one VDB? Thanks
25-03-2019 09:13:28 -0400

1 Answer

Hi, Some of the [Predefined stored procedures]( of Denodo Platform are designed to accept mandatory input parameters for better performance. A stored procedure can be used as a view, allowing them to be joined with other stored procedures/views to explore on the metadata information. For this scenario, I performed a join operation between the stored procedures [GET_SOURCE_COLUMNS()](, [GET_SOURCE_TABLE()]( and [GET_VIEWS()]( to pass all view names of a database and achieved the desired information. Note that, this join operation is designed to return the source information of JDBC base views. I can also retrieve the source columns information from the base view by using the predefined stored procedure [CATALOG_VDP_METADATA_VIEWS ()]( This procedure does not require any mandatory parameters. Since this procedure is designed to be used for all types of views, I would use the view_type=0 as a filter to restrict only base views. If you need to further describe the elements of the Virtual DataPort server, you can refer to [‘DESC VQL’]( statement. Hope this helps!
Denodo Team
26-03-2019 06:48:03 -0400
You must sign in to add an answer. If you do not have an account, you can register here