Hi,
As mentioned in this similar [Community Q&A question](https://community.denodo.com/answers/question/details?questionId=9060g000000Xep5AAC&title=Automate+Source+Refresh), you could combine the [GET_SOURCE_CHANGES](https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources) and [GET_VIEWS](https://community.denodo.com/docs/html/browse/latest/vdp/vql/stored_procedures/predefined_stored_procedures/get_views#get-views) predefined stored procedures to detect changes in the source and then automate the detection process using a Scheduler job. 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 explains how to do this in detail.
Then, depending on the base views with changes in the underlying data sources, you should use the base view [source refresh](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/source_refresh/source_refresh#source-refresh) functionality to refresh the metadata and propagate those changes to the affected derived views. As of now, this is the only way to perform the actual source refresh.
Hope this helps!
