[FEATURE]: Remove skipped tables/schemas through CLI

databrickslabs / ucx

Automated migrations to Unity Catalog

Other

216 stars 75 forks source link

[FEATURE]: Remove skipped tables/schemas through CLI #1938

Open maruppel opened 2 months ago

maruppel commented 2 months ago

Is there an existing issue for this?

[X] I have searched the existing issues

Problem statement

Can currently skip schemas/tables but doesn't seem to be anyway to remove skip table properties from CLI.

Proposed Solution

Add additional parameter to skip command to restore the object, or created new command unskip.

Additional Context

No response

JCZuurmond commented 1 month ago

@maruppel : Could you please clarify the issue? I am not understanding it well enough.

remove skip table properties

You want functionality to remove table properties set by ucx?

maruppel commented 1 month ago

It seems we can set the property: ((databricks.labs.ucx.skip, true)) but as far as I can tell, there is no way to unset without running an ALTER in the UI. Additionally it seems only empty string constitutes as a false, ie the table is still skipped when the value is set as ((databricks.labs.ucx.skip, false)).