What happens when a Snowflake user changes the data retention period at the schema level?

Question

Options

• AAll child objects will retain data for the new retention period.
• BAll child objects that do not have an explicit retention period will automatically inherit the new
• CAll child objects with an explicit retention period will be overridden with the new retention period.
• DAll explicit child object retention periods will remain unchanged.

• A
  2% (1)
• B
  91% (49)
• C
  6% (3)
• D
  2% (1)

Explanation

Snowflake uses an inheritance model for Time Travel data retention periods. When you change the retention period at the schema level, only child objects (tables, etc.) that do not have an explicitly set retention period will inherit the new schema-level value. Child objects that already have an explicit retention period defined will retain their own explicit setting and are NOT overridden. This allows fine-grained control while still supporting top-down defaults.

No community discussion yet for this question.