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.

AzharuddinK

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




nVector18-Nov-19

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';

AzharuddinK18-Nov-19

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?

nVector18-Nov-19

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