Takuya-Omi
Valued Contributor III

Hi @schluca ,
I’ve encountered an issue where an error occurred when trying to reference a table after deleting and recreating the source table for a Shallow Clone, and then performing the Shallow Clone again. As a solution, try deleting the destination table of the Shallow Clone and then running the Shallow Clone process again.

%sql
DROP TABLE shallowclone_test.testschema.clonned_table;

CREATE OR REPLACE TABLE shallowclone_test.testschema.clonned_table 
SHALLOW CLONE shallowclone_test.testschema.original_table;

 

--------------------------
Takuya Omi (尾美拓哉)