Hi,
From what I understand, you would like to automate the detection of new tables in an existing data source and creation of your base views in the Virtual DataPort. I believe you can do this by using some predefined stored procedures that are available in the Virtual DataPort. To do this, you can follow these steps:
1. Get the list of existing base views by using [GET_VIEWS](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_views) and [GET_SOURCE_TABLE](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_source_table) stored procedures
2. Get the list of tables in the data source using [GET_JDBC_DATASOURCE_TABLES](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_jdbc_datasource_tables) stored procedure
3. Combine the results of the 2 tables to get the list of new tables
4. Generate the VQL scripts to create the base views of the new tables using [GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/generate_vql_to_create_jdbc_base_view)
You can further check the answer in this community question [Automating creation of base views using Generate VQL Script and Get Source Table stored procs](https://community.denodo.com/answers/question/details?questionId=906Du00000000SRIAY&title=Automating+creation+of+base+views+using+Generate+VQL+Script+and+Get+Source+Table+stored+procs), which guides you on how to combine these stored procedures to achieve your need.
You can also refer to this article [How To Detect Changes In Data Sources](https://community.denodo.com/kb/en/view/document/How%20to%20detect%20changes%20in%20data%20sources) for a detailed guide on how you can set up a Denodo Scheduler job to automate the detection of changes in your data sources.
Hope this helps!
