Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2024 05:46 PM
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 (尾美拓哉)
Takuya Omi (尾美拓哉)