Incremental/Repeated Re-execution of Assessment workflow

[JinHash5]

Is there an existing issue for this?

• I have searched the existing issues

Problem statement

1. Can we please make assessment workflow re-execution a feature? Currently assessment is designed to work only once and if the user needs a re assessment of the workspace, he would have to uninstall and reinstall ucx from scratch owing to a lot of re work and time consumption.

Proposed Solution

Lets say user has 5 objects in HMS. User runs the assessment workflow. Now, there is a business need to create 3 more objetcs in HMS and migrate all the 8 objects to target schema.
With the current setup, since the assessment workflow was executed before the creation of new objects, only the existing 5 objects will be migrated. To include all 8, user will have to uninstall ucx, reinstall ucx from scratch and then run the assessment workflow from scratch.

Incremental/repeated can be designed by simply adding runid flags to the assessment workflow target tables and by default always refer to the data of the maximum runid. This will also enable storing historical assessment workflow results in the same table.

Additional Context

No response