[FEATURE]: Support External HMS with Federation

[FastLee]

Is there an existing issue for this?

• I have searched the existing issues

Problem statement

We currently support only internal HMS for federation

Proposed Solution

Allow creating a federated catalog for external HMS.

Additional Context

No response