Knowledge Graph — Coursera Notes › Academic disciplines › Computer Science / Information Technology › Cloud Computing › Snowflake

Snowflake Time Travel

feature · part of Snowflake

A Snowflake feature that allows accessing previous versions of data, schemas, and tables within a defined retention period.

Inside Snowflake Time Travel (5)

• AT — A clause in Snowflake Time Travel queries used to specify a historical point in time by timestamp or offset.
• BEFORE — A clause in Snowflake Time Travel queries used to specify a state before a given statement.
• CLONE — A SQL command to create a copy of a table as it existed at a past point in time using Time Travel.
• DATA_RETENTION_TIME_IN_DAYS — A parameter that controls the number of days data is retained for Time Travel.
• UNDROP — A SQL command to restore dropped tables, schemas, or databases within the Time Travel retention period.

Connections

• Related to Fail-safe
• Uses Snowflake cloning
• Uses CLONE
• Uses Session Variable
• Related to Permanent table
• Related to Transient table
• Related to Temporary table

This is the text view of an interactive 3D knowledge graph — open this page with JavaScript enabled to explore it visually.