...

1. Get a list of all dependents of the view dropped and their cache status

   Code Block
   select   distinct vd.view_database_name, vd.view_name, v.cache_status from view_dependencies() vd left join get_views() v on v.name = vd.view_name and v.database_name = vd.view_database_name where dependency_name = 'VIEW_NAME' and private_view = 'false';

2. Get the latest VQL backup for the environment where the drop occured. This could be a development backup in S3, or a deployment backup. See the sections above for their locations.

3. Assemble a VQL file containing the relevent CREATE, ALTER, CHOWN, and ALTER ROLE statements for each view. Be sure to include CONNECT DATABASE and CLOSE; statements for each database.

4. Create a revision in Solution Manager, validate and deploy.

See who has completed the Denodo training

select * from training.abs_denodo_course_completion

https://denodo-dev.it.tufts.edu:9443/denodo-data-catalog/#/view/training/abs_denodo_course_completion

User Guide

Anchor
denodo-user-guide denodo-user-guide

...