How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?

Question

Options

• ACreate transient tables and periodically copy them to permanent tables.
• BCreate temporary tables and periodically copy them to permanent tables
• CCreate regular tables with extended Time Travel and Fail-safe settings.
• DCreate regular tables with default Time Travel and Fail-safe settings

• A
  74% (23)
• B
  13% (4)
• C
  10% (3)
• D
  3% (1)

Explanation

Continuous Data Protection (CDP) in Snowflake includes Time Travel and Fail-safe storage, which both incur additional storage costs proportional to the volume of data changed (churn). For large, high-churn tables, these costs can be substantial. Transient tables have NO Fail-safe period and support only 0 or 1 day of Time Travel, drastically reducing CDP storage overhead. Periodically copying the transient table to a permanent table captures a stable snapshot for recovery purposes. Option B (temporary tables) is session-scoped and disappears when the session ends - not suitable for persistent data. Options C and D both involve regular tables with full CDP costs, which would increase rather than minimize costs.

No community discussion yet for this question.