[FEATURE]: External Metastores - Generate a separate UCX Schema by workspace

[FastLee]

Is there an existing issue for this?

• I have searched the existing issues

Problem statement

When installing UCX on a workspace with an external metasatore we risk overriding the UCX schema of another workspace.
External metastores are typically shared between workspaces (as oppose to the built in HMS).
Using a single default schema name (UCX) will cause a conflict and will have the newer installation override older installations.

Proposed Solution

When detecting an external metastore we have to create a unique default schema name by workspace.
I would suggest ucx-[workspace_id]

Additional Context

No response

[FastLee]

I think this is more about external metastore than workspace collection.