You can translate the question and the replies:

Denodo detect new table and create metadata

Can Denodo detect when new table are added to the existing database that is already connected to denodo and automatically create metadata of that table in denodo?
27-06-2023 23:44:10 -0400

1 Answer

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]( and [GET_SOURCE_TABLE]( stored procedures 2. Get the list of tables in the data source using [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]( 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](, 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]( 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!
Denodo Team
28-06-2023 23:41:27 -0400
You must sign in to add an answer. If you do not have an account, you can register here