SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ46

VerifiedImplement Data Protection and Recovery

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?

Choose two
Explanation

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.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!