You can translate the question and the replies:

desc datasource meta info

Hello , I am trying to get the metadata information using desc datasource command. While I am running desc datasource jdbc "source_name" in VQL Shell, we could see the full output. Whereas if we are creating view using the same command and using the interpolation variable to pass "source_name" , I am not getting the full output as we run on VQL Shell. I could see the fields where restricted for each type in the below document I would like to get "testOnBorrow" info too in my output . Is there any other way to get this info. Thanks Rajesh
27-04-2023 09:29:46 -0400

1 Answer

Hi, When you execute the DESC DATASOURCE_JDBC <Datasource> command from the VQL Shell of the Administration Tool instead of a JDBC client, it will return information that should only be used for debugging purposes and can change between updates of the Denodo Platform. instead of using the DESC DATASOURCE JDBC <DataSource> command you can create a view using the DESC VQL DATASOURCE JDBC <DataSource> command which will return the VQL information of your Data Source, including testOnBorrow. As this VQL information is included in a single Text column, you will need to parse the Text to get your information. You can find more information on how to parse Text with Denodo Functions in Section [Text Functions]( of the Virtual Dataport VQL Guide. Hope this Helps!
Denodo Team
28-04-2023 10:41:49 -0400
You must sign in to add an answer. If you do not have an account, you can register here