A Data Engineer is using Time Travel to clone a table with this query:
CREATE TABLE MY_TABLE_CLONE CLONE MY_TABLE AT (OFFSET => -60*30);
An error is returned.
What could be causing the error?
Snowflake external tables do not support cloning or Time Travel, so an external table cannot be cloned with this statement. Snowflake also returns an error when the source object did not exist at the time specified by the AT | BEFORE clause.
AT | BEFORE
Community Discussion