16 Nov 19 · AzharuddinK · #Snowflake ·   Bookmark   ×

Is there a way to identify tables that were created by cloning in the database ?

Want to get a list of tables which were created in the Snowflake database using the clone command.


posted on 16 Nov 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

npackNov 18 12:49

Whenever you clone a table or schema. You can also add a second step to add a comment that indicates its a cloned table

comment on Table my_table is 'This Table is a Cloned table';

AzharuddinKNov 18 06:48

Yes ... that makes sense going forward.

Doesn't System Information tables have something that can help me out to identify that the tables are cloned?

npackNov 18 11:36

Yeah, i don't see anything related in system table

Community Software by Hittly