SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ11

Data Storage and Processing

A company has a table named Data that contains corrupted data. The company wants to recover the data as it existed 5 minutes ago by using cloning and Time Travel.

Which command will accomplish this?

Explanation

Snowflake creates a historical zero-copy table clone with CREATE TABLE <new_table> CLONE <source_table> AT(OFFSET => <seconds>). An offset of -60*5 specifies 300 seconds before the current time, which is five minutes ago.

Learn more

Community Discussion

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