Mapping Flow from Old [HMS] to new [UC] For External Tables

[pohlposition]

Database / Schema > UC Catalog

• May want to prefix / suffix a database name

Database may map to 1 or more Catalogs

Defined Table Migration Process defined in this PR: #307

Probably a file that someone downloads, modifies, and uploads (offline mapping)

[pohlposition]

Dependencies:

• Is there a mechanism for handling downloads / uploads

[william-conti]

Probably we would need to have the workspace id/name in the mapping as it can happen to have the same database name between workspaces. thus creating a conflict

[pohlposition]

Need to detect conflicts and dedupe. #335

[nfx]

@pohlposition let's merge newer issues into older issues :)

[nfx]

@pohlposition :thinks realistically, we need to have an out-of-band job that can "move" objects to new catalogs. Because you're going to register a table in CATALOG.SCHEMA (A), and then realize later that it doesn't belong there for other workspaces that were referencing it.

[nfx]

closing in favor of #669