Hi,

I would like to clone the structure (schema only) of delta table without the content using SHALLOW CLONE command, as recommended in databricks documentation, but it doesn't work. I get an error message that this command is not supported in Unity Catalog. However, DEEP CLONE does work well.

Please find below my code and he error message:

CREATE OR REPLACE TABLE facility_silver SHALLOW CLONE facility_bronze;
 
 
Error in SQL statement: AnalysisException: [UC_COMMAND_NOT_SUPPORTED] CREATE TABLE SHALLOW CLONE is not supported in Unity Catalog.;

Anything wrong with my code?

How to clone delta table schema without its content?

Thanks,