To create a base view from the query “DESC Datasource JDBC <JDBC datasource>”, I would create a JDBC datasource with one of the Denodo Virtual DataPort adapters and create a base view from query with database name and data source name as interpolation variables. For example:
**DESC DATASOURCE JDBC @inp1.@inp2**
Where inp1 is database name and inp2 is data source name.
Note that while creating the view, you will be prompted to provide values to inp1 and inp2, you can provide any possible value. It’s just required for view creation. After the view creation these input values are provided at execution time to get the results.
Once the base view is created, I would follow the below steps:
* Open the base view
* Go to Options -> Search Methods -> wrapper source configuration
* Set “Delegate SQL sentence as Sub Query” to No
This would send the query as it is to the datasource instead of sending as a subquery.
You can also refer to a similar [Q&A](https://community.denodo.com/answers/question/details?questionId=9060g0000004ElSAAU&title=data+source+connection+string+information).
Hope this helps!