You can translate the question and the replies:

GENERATE_VQL_TO_CREATE_<json>_BASE_VIEW()

Hey, There is a stored procedure to generate vql to create base view for jdbc sources - GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW() but is there a option i can generate vql for otehr datasource. I.e json, csv, custom, etc
user
07-02-2020 05:44:03 -0500

1 Answer

Hi, As you said, I would use the predefined stored procedure [GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/generate_vql_to_create_jdbc_base_view#generate-vql-to-create-jdbc-base-view) to generate VQL for base views on JDBC data sources. To create a base view on a non-JDBC data source, I do it either [graphically](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/creating_data_sources_and_base_views) through Virtual DataPort Administration Tool or by writing my own VQL, following the syntax outlined in the ["Creating a Base View"](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/creating_a_base_view/creating_a_base_view#creating-a-base-view) section of the Virtual DataPort Developer Guide. Hope this helps!
Denodo Team
07-02-2020 20:22:19 -0500
You must sign in to add an answer. If you do not have an account, you can register here