Hi @Rajasaiharish !
Yes, that's correct! In hive/CDP (HMS word) rename operation (ALTER TABLE RENAME) automatically renames the directory in HDFS to match because Hive Metastore directly controls both the metadata and the storage path.

But in Databricks, UC separates logical metadata (catalogue/schema/table) from physical storage.

 

Anudeep