You can translate the question and the replies:

Enforcing source alignment within base views

Related to: How to detect changes in data sources
Hi there, Is there a method where any changes made on a source table can be automatically 'enforced' on a base view table? The purpose being the ability to always keep base views in line with the LAG version of its source table? Likewise, should the source table have been removed/dropped, the base view would then also be dropped. In essence, is there a way to do a bulk, automated "Source Refresh" across all base views? Kind regards, Vincent J
Create Base View SOURCE_CHANGES()
user
22-03-2023 06:08:47 -0400
code

1 Answer

Hi, I’ve found a similar question about automated Source refreshed. [Manage change from Data Source](https://community.denodo.com/answers/question/details?questionId=9064u000000Cel5AAC&title=Manage+change+from+Data+Source). I’d recommend to check it out. According to the answer, you should use the GET_SOURCE_CHANGES procedure that returns information about differences between Denodo views and the associated table in the underlying data source and use the GET_VIEWS procedure in conjunction with that procedure to execute the procedure on all of my base views. For more information about these stored procedures, you can reference the [GET_SOURCE_CHANGES](https://community.denodo.com/docs/html/browse/latest/vdp/vql/stored_procedures/predefined_stored_procedures/get_source_changes#get-source-changes) and [GET_VIEWS](https://community.denodo.com/docs/html/browse/latest/vdp/vql/stored_procedures/predefined_stored_procedures/get_views#get-views) sections of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
23-03-2023 09:06:39 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here