Question

A data engineering team needs the ability to configure Time Travel retention on critical permanent tables for up to 90 days to support recovery and auditing requirements. Their organization currently runs on Snowflake Standard Edition. What is the minimum edition they must move to in order to set a data retention period of 90 days?

Accepted Answer

Enterprise Edition, which raises the maximum Time Travel retention for permanent objects to 90 days

Answer

Standard Edition, since it already supports up to 90 days of Time Travel

Answer

Business Critical Edition, because extended Time Travel requires HIPAA-level compliance features

Answer

Virtual Private Snowflake (VPS), which is the only edition that unlocks retention beyond 1 day