You can translate the question and the replies:

Refresh the Data Source completely

Can I Refresh the Data Source completely not base view by base view if I altered the schema at the source?
user
17-06-2020 12:38:34 -0400

1 Answer

Hi, When you use the 'Source refresh' option for a view to reflect the altered schema from the source in the Virtual DataPort, it could also affect the schema of its dependent views. If you would still want to 'Source refresh' all the base views, you can use a combination of the following predefined VQL stored procedures to execute a VQL statement to implement the same, * [GET_SOURCE_CHANGES](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_source_changes) * [GET_VIEWS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_views) * [GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/generate_vql_to_create_jdbc_base_view) The created VQL statement could also be automated using the Denodo Scheduler to periodically execute this statement to refresh the views. Hope this helps!
Denodo Team
18-06-2020 08:07:59 -0400
You must sign in to add an answer. If you do not have an account, you can register here