Since we cannot really trust if the underlying external catalog can throw exceptions when there is an invalid metadata operation, let's do it in SessionCatalog.
Verification of partition specs in SessionCatalog
Table/Database Name Validation in SessionCatalog
[Github] Pull Request #12385 (gatorsmile)
[Github] Pull Request #13126 (gatorsmile)