Dynamic tables: Updates to dynamic table default refresh mode¶

A dynamic table’s actual refresh mode is determined at creation time and is immutable afterward. If not specified explicitly, the refresh mode defaults to AUTO. When the 2024_04 behavior change bundle is enabled, Snowflake chooses the refresh mode that’s likely to perform best depending on your query definition.

To determine the best mode for your use case, experiment with refresh modes and automatic recommendations. For consistent behavior across Snowflake releases, Snowflake recommends that you explicitly set the refresh mode on all production dynamic tables.

For more information, see best practices and limitations around using incremental refresh.

Before the change:

Snowflake chooses an incremental refresh of the dynamic table by default. If the dynamic table’s definition doesn’t support the incremental refresh mode, the dynamic table is automatically created with the full refresh mode.

After the change:

Snowflake chooses the refresh mode that is likely to perform best depending on your query definition.

For consistent behavior across Snowflake releases, you should explicitly set the refresh mode on all production dynamic tables.

Ref: 1614