Is there an existing issue for this?

• I have searched the existing issues

Problem statement

Currently create-catalog-schema doesn't validate the external location keyed in by the user and will fail if an erroneous location is keyed in.
Related:

• Added 'create-catalogs-schemas' command to prepare destination catalogs and schemas before table migration #1028
• create-catalogs-schemas should work for external paths #1039
• [CUJ]: Target catalogs creation #900

Proposed Solution

Validate external locations before creating the catalog. Alert the user if the external location selected is not working.

Additional Context

No response