MuthuLakshmi
Databricks Employee
Databricks Employee

@ashraf1395 
To migrate managed tables stored at DBFS root to UC, you can do it through Deep Clone or Create Table As Select (CTAS). This also means that the HMS table data needs to be moved to the cloud storage location governed by UC. Please ensure the location given as the S3/ABFS path is anything that's not the metastore root storage path.

Deep clone: https://docs.databricks.com/sql/language-manual/delta-clone.html

CTAS: https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html#related-a...