You can translate the question and the replies:

Metadata proc - datasource for a base view

Is there a predefined stored proc where I can see the details of the datasource for a base view? I've been looking through but can't seem to find this info. I can find the source database name, the schema and the table but not the datasource for it. I am looking to be able to retrieve the server from the server URI details
13-06-2019 07:16:02 -0400

3 Answers

Hi, You can execute the DESC command to see the details of a data source, e.g. for the jdbc data source ``` DESC DATASOURCE JDBC <data source name> ``` Please, refer to the section [Output Schema of the DESC Commands]( in the Virtual DataPort Developer Guide for more information. Additionally, if you have a valid support account, you can open a support ticket for any further question about Denodo Platform. Hope this helps!
Denodo Team
14-06-2019 03:39:27 -0400
I probably wasn't clear, I am looking to be able to get this info for a report so would need to be able to retrieve this info via a SQL statement on Denodo
14-06-2019 03:47:04 -0400
Hi, To extract the detailed information for report review, you could develop a custom stored procedure or create a view based on the DESC command. Currently, the stored procedure for extracting that information directly does not exist. You can refer to the section [Developing Stored Procedures]( and also a similar community question in this [link]( Hope this helps!
Denodo Team
14-06-2019 04:07:08 -0400
You must sign in to add an answer. If you do not have an account, you can register here