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,