How does Snowflake handle the data retention period for a table if a stream has not been consumed?

Question

Options

• AThe data retention period is reduced to a minimum of 14 days.
• BThe data retention period is permanently extended for the table.
• CThe data retention period is temporarily extended to the stream's offset.
• DThe data retention period is not affected by the stream consumption.

• A
  4% (1)
• B
  4% (1)
• C
  91% (21)

Explanation

When a stream exists on a table but has not been consumed, Snowflake automatically extends the table's data retention period to ensure the stream's offset (the point in time from which changes are tracked) remains accessible. This extension is temporary - it lasts only as long as the stream remains unconsumed. Once the stream is consumed (or dropped), the retention period returns to its configured value. This prevents Time Travel data that the stream depends on from being purged prematurely.

No community discussion yet for this question.