Add `adaptive` refresh mode option for dynamic tables

[arifischer]

Company Name

Runna

Use Cases or Problem Statement

On July 30th, 2026, Snowflake made the ADAPTIVE dynamic table refresh mode generally available.

However, this is not yet reflected in the terraform provider. When running our terraform plan using the ADAPTIVE refresh mode, we get errors like the below:

Error: Invalid value for variable

  on terraform-modules/path/to/my_table.tf line xx, in module "my_table":
  19:   refresh_mode = module.tables_config.dynamic_table_refresh_mode.adaptive
    ├────────────────
    │ var.refresh_mode is "ADAPTIVE"

Invalid refresh mode, must be one of: AUTO, INCREMENTAL, FULL.

Please can the ADAPTIVE refresh mode be added to the provider? It's quite a great feature that allows Snowflake to determine whether an incremental refresh would be more expensive than a reinitialisation and adjust accordingly.

Category

category:snowflake

Object type(s)

resource:dynamic_table

Proposal

No response

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jcieslak]

Hey @arifischer, will add it. Should be available in the next provider version.

[sfc-gh-jcieslak]

Hey @arifischer, the adaptive mode is now available in the 2.20.0 version of the provider: https://github.com/snowflakedb/terraform-provider-snowflake/blob/main/MIGRATION_GUIDE.md#new-feature-adaptive-refresh-mode-for-dynamic-tables. What I saw just now is that it's not well described in the Terraform Registry for the dynamic table resource... will address it next version, but once you upgrade it's usable. After you try it or feel the request was addressed, please close the issue. Thanks 👍