Mar 02, 2026: Support for new dbt Core versions for dbt Projects on Snowflake

Snowflake now supports explicit version pinning for dbt projects with the new DBT_VERSION parameter. You can pin a dbt Core version when creating, altering, or executing a dbt project object. You can also query supported versions and engine types using the SYSTEM$SUPPORTED_DBT_VERSIONS system function to plan upgrades and maintain environment stability.

The following example creates a dbt project pinned to a specific dbt Core version:

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

The following example overrides the project’s pinned version at execution time:

EXECUTE DBT PROJECT my_dbt_project
  DBT_VERSION = '1.10.15';
Copy

This release also introduces the following changes:

  • The DEFAULT_DBT_VERSION account parameter enables organization administrators to set a default dbt version for all future dbt project objects created in the account without requiring users to manually update CREATE DBT PROJECT DDL statements for every individual project.

  • The DESCRIBE DBT PROJECT and SHOW DBT PROJECTS commands now return dbt_version and dbt_snowflake_version columns.

  • The DBT_PROJECT_EXECUTION_HISTORY table function now returns DBT_VERSION and DBT_SNOWFLAKE_VERSION columns for auditing which engine version was used for each run.

For more information about the dbt Core versions that Snowflake supports, see Supported dbt Core versions for dbt Projects on Snowflake.