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 https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/appendix/output_schema_of_the_desc_commands/output_schema_of_the_desc_commands I would like to get "testOnBorrow" info too in my output . Is there any other way to get this info. Thanks Rajesh
desc datasource pool configuration 3
user
27-04-2023 09:29:46 -0400
code

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](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/text_functions/text_functions) of the Virtual Dataport VQL Guide. Hope this Helps!
Denodo Team
28-04-2023 10:41:49 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here