SnowPro Associate Platform SOL-C01

By Snowflake · Question Mode

QuestionQ56

Load and leverage structured, semi-structured, and unstructured data

Which Snowflake feature should be used to select data from a table as it was configured 5 minutes ago?

Explanation

Snowflake Time Travel enables queries against historical table data at a specified prior time. Its AT (OFFSET => -60*5) syntax retrieves the table state from five minutes earlier, provided that point is within the Time Travel retention period.

Learn more

Community Discussion

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