CLONE a table in Snowflake

 

Clone a Table in Snowflake 

So simple, 

CREATE TABLE TableName_Clone CLONE OriginalTableName

To restore a table at a specific timestamp 

CREATE TABLE TableName_Clone  CLONE OriginalTableName

AT  (TIMESTAMP => TO_TIMESTAMP_TZ('11/04/2024 00:00:00', 'dd/mm/yyyy hh24:mi:ss'));