Skip to main content

Snowflake adapter behavior changes

The snowflake_default_transient_dynamic_tables flag​

Available starting dbt-snowflake v1.12. The snowflake_default_transient_dynamic_tables flag controls whether Snowflake dynamic tables are created as transient when the model config does not explicitly set the transient config.

  • When set to False (default): Dynamic tables are created as permanent tables with a Fail-safe period unless you set transient: true for a specific model.
  • When set to True: Dynamic tables are created as transient (no Fail-safe period) when transient is not specified in the model config. Transient dynamic tables can reduce storage costs.

Set the snowflake_default_transient_dynamic_tables flag in your dbt_project.yml under the flags key. You can override the default setting using the transient config on dynamic table models.

Was this page helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

0
Loading