Time Travel retention periods in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Time Travel in Snowflake?

Time Travel lets you access historical data from a table or database as it existed at a past time or before a change happened.

beginner

What is the default Time Travel retention period for standard Snowflake accounts?

The default retention period is 1 day (24 hours) for standard accounts.

intermediate

What is the maximum Time Travel retention period available in Snowflake Enterprise Edition and above?

Up to 90 days of Time Travel retention is available in Enterprise Edition and higher.

intermediate

How does Time Travel retention period affect storage costs?

Longer retention periods keep more historical data, which increases storage usage and costs.

intermediate

Can you change the Time Travel retention period for a table after it is created?

Yes, you can alter the retention period for a table using SQL commands, within allowed limits based on your Snowflake edition.

What is the default Time Travel retention period for Snowflake standard accounts?

A 7 days

B 30 days

C 1 day

D 90 days

Standard Snowflake accounts have a default Time Travel retention period of 1 day (24 hours).

Which Snowflake edition supports up to 90 days of Time Travel retention?

A Standard Edition

B Enterprise Edition

C Free Trial

D Developer Edition

Enterprise Edition and above support up to 90 days of Time Travel retention.

What happens to storage costs when you increase the Time Travel retention period?

A Costs increase

B Costs stay the same

C Costs decrease

D Costs are refunded

Longer retention means more data is kept, which increases storage costs.

Can you access data from 10 days ago if your Time Travel retention is set to 7 days?

A Only if data was archived

B Yes, always

C Yes, but only with special permission

D No, only within retention period

You can only access historical data within the retention period set.

How do you change the Time Travel retention period for a table?

A Using ALTER TABLE command

B Using CREATE TABLE command

C Using DROP TABLE command

D Using SELECT command

You use ALTER TABLE to modify the retention period of an existing table.

Explain what Time Travel retention period means in Snowflake and why it matters.

Think about how long you can go back in time to see old data.

Describe how Snowflake editions affect the maximum Time Travel retention period available.

Different editions offer different time windows for Time Travel.