Supported dbt Core versions for dbt Projects on Snowflake

Snowflake provides managed runtimes for dbt Projects to ensure a secure and predictable execution environment. Because dbt Core releases can introduce breaking changes or security vulnerabilities, Snowflake follows a structured lifecycle for each version. This policy allows users to pin specific versions for governance and reproducibility while providing a clear timeline for required migrations.

Supported versions for dbt Projects

dbt Core Version Supported

Snowflake Support Level

dbt Labs Support

1.10.15

Active support

Critical support since Jun 15, 2026

1.9.4

Active support

Deprecated

The DBT_VERSION parameter implicitly defines the execution engine based on the version, as shown in the table below.

Version based engine mapping

User Input (DBT_VERSION)

Condition

Resulting Engine

‘1.x’ (for example, 1.9.4)

Version < 2.0

dbt Core (Python-based)

View supported dbt Core versions

To view supported dbt Core versions, run the SYSTEM$SUPPORTED_DBT_VERSIONS system function, as shown in the following example:

SELECT SYSTEM$SUPPORTED_DBT_VERSIONS();
Copy
[{"dbt_version":"1.9.4","type":"dbt Core"},{"dbt_version":"1.10.15","type":"dbt Core"}]

Alter dbt Core execution version

To alter the dbt Core version that the dbt project object will execute, run the ALTER DBT PROJECT command as shown in the following example:

ALTER DBT PROJECT my_dbt_project SET DBT_VERSION = '1.10.15';
Copy

Create a dbt project pinned to a version

The following example creates a dbt project pinned to the 1.10.15 dbt version:

CREATE OR REPLACE DBT PROJECT my_dbt_project
  FROM '@my_stage/dbt_files'
  DBT_VERSION = '1.10.15';
Copy

For more information and examples, see CREATE DBT PROJECT and ALTER DBT PROJECT.

How deprecation and decommissioning work

  • Snowflake supported versions: These versions are available for all new and existing projects. Snowflake provides full technical support, including security patches.

  • Snowflake deprecated versions: These versions have reached the end of their active development cycle. While they remain fully functional for existing projects, users are discouraged from starting new projects on a deprecated version.

  • Snowflake decommissioned versions: These versions are officially removed from the Snowflake environment. At this stage, any project pinned to a decommissioned version will fail to execute until it’s updated to a currently supported version.

  • dbt Core Support Levels: Even if a version reaches Critical Support, Deprecated, or End of Life status according to dbt Labs (https://docs.getdbt.com/docs/dbt-versions/core#latest-releases), it remains supported on Snowflake. This means that you aren’t forced into immediate upgrades and can maintain your existing environment for as long as you choose.