You can translate the question and the replies:

Base Views source Refresh automation

Hi, my question is about how to automate the update of the base views in Denodo 8.0. When adding fields to tables in AWS connecting with a jdbc source to Athena. Still has to be done manually, or is there any procedure for it to be automated? Thankyou.
user
08-11-2021 05:58:06 -0500
code

1 Answer

Hi, In the Denodo Platform, you can automate the process of detecting the changes in the data sources by creating a job in the Denodo Scheduler using the [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) stored procedures. By using the **“Source Refresh”** option available on the **“Edit”** tab of the base view in the Virtual Dataport, you could propagate the changes from the underlying data source. For more information, you can also refer to the knowledge base article [How to detect changes in data sources](https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources). As of now, it is only possible to do source refresh for each base-view by choosing the [Source Refresh](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/creating_data_sources_and_base_views/source_refresh/source_refresh) manually. You can also refer to related community QA at [Automate Source Refresh](https://community.denodo.com/answers/question/details?questionId=9060g000000Xep5AAC&title=Automate+Source+Refresh) for more information. Hope this helps!
Denodo Team
09-11-2021 05:51:52 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here