What's the recommended way of creating tables in Databricks with unity catalog (External/Managed)

Shivap
New Contributor III

I have databricks with unity catalog enables and created an external ADLS location. when I create the catalog/schema it uses the external location. when I try to create the table it uses the extrenal location but they are managed tables. What's the recommended way of creating tables in Databricks with unity catalog. How I can create an external table with Unity catalog enabled -

 

CREATE external TABLE test_catalog.test_schema.test(  
name STRING
) LOCATION 'abfss://databricks-storage@saXXX0101.dfs.core.windows.net/'