Converting Managed Hive Metastore Table to External Table with Mount Point Location

shweta_m
New Contributor III

We have a managed Hive Metastore (HMS) table, and we would like to convert it into an external table and the location of that external hms table as mount points.

Walter_C
Databricks Employee
Databricks Employee

You could create the table as external table by using CREATE TABLE student_copy AS SELECT * FROM student; to pull the data from the managed table.