You can translate the question and the replies:

denodo base view refresh

We have scenario where we need to refresh base views using scripts/VQL. Is there a script to mass refresh base views and confirm with single script?
user
05-03-2021 13:32:28 -0500

3 Answers

Hi, You could use the combination of predefined stored procedures such as **[GET_SOURCE_CHANGES](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_source_changes#get-source-changes)** and **[GET_VIEWS](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_views#get-views)** which returns the differences between the current schema of a base view and its underlying data source. After you obtain the list of views with changes, you could use the **[Source Refresh](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/source_refresh/source_refresh#source-refresh)** option available in the **Edit** tab of the base views that have been modified. You can find a similar community at **[Automate Source Refresh](https://community.denodo.com/answers/question/details?questionId=9060g000000Xep5AAC&title=Automate+Source+Refresh)** which suits your scenario. For more information, you can take a look at the**[ How to detect changes in data sources](https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources)** Knowledge Base Article. Hope this helps!
Denodo Team
08-03-2021 05:20:22 -0500
Thanks for your answer, Though, we are aware of identifying the change using predefined stored procedures. We are aware of doing source refresh using VDP interface. Is there a way to source refresh base views **without using VDP interface** ? Either using script or VQL. Appreciate your help.
user
08-03-2021 11:04:16 -0500
Hi, You can automate the process of detecting the changes in the data sources by creating a job in the Denodo Scheduler using **SOURCE_CHANGES** stored procedure. Once detected, It is only possible to use the Source Refresh option of the Virtual DataPort Administration Tool to manually perform the Source Refresh. Hope this helps!
Denodo Team
15-03-2021 08:46:28 -0400
You must sign in to add an answer. If you do not have an account, you can register here