NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI · #1630 most downloaded on PyPI
The Snowflake adapter plugin for dbt
Last release 18 days ago
16 Sep 2026
Ships fairly regularly
a new release about every 3 weeks
Some releases are documented
notes for 32 of the last 60 stable releases
1 version withdrawn
withdrawn after publishing
8 years old
210 releases · first in 2019
Add beta support for the Snowflake interactive_table materialization, covering static and dynamic (auto-refreshing) interactive tables with target_lag
interactive_table materialization, covering static and dynamic (auto-refreshing) interactive tables with target_lag, cluster_by, refresh/initialization warehouses, and in-place configuration changes via ALTER where Snowflake supports it (#1780)change_tracking=false for Iceberg tables instead of emitting invalid DDL, since Snowflake does not allow change tracking to be turned off for Iceberg tables (#0)SHOW ... LIKE metadata queries for dynamic and interactive tables: a model whose name contained a quote terminated the SQL string literal early, so describing the relation failed or ran unintended SQL (#)my_wh compared against a reported MY_WH was treated as a change and fired a spurious ALTER on every run (#)SHOW never echoes the quotes back, so a quoted snowflake_warehouse/refresh_warehouse/ snowflake_initialization_warehouse value never compared equal to its own readback and fired a spurious ALTER on every run (#)to_char(ts, 'MON')) as case-sensitive data during configuration-change detection: the surrounding expression text was folded correctly, but a literal's exact case, and any )/, characters embedded inside it, previously corrupted the comparison and could cause an unnecessary full refresh on every run. Live-verified against Snowflake (#)One column per quarter.
Add transient support for Snowflake dynamic tables via transient config option and snowflake_default_transient_dynamic_tables behavior flag.
transient config option and snowflake_default_transient_dynamic_tables behavior flag. (#716)iceberg_version config to enable Iceberg V3 table creation via model config or catalogs.yml adapter_properties. (#1779)tmp_relation_type=transient support for incremental models, enabling Snowflake lineage tracking; add snowflake__resolve_incremental_tmp_relation dispatch macro for controlling tmp relation destination (#1893)list_relations_without_caching to include function relations (#1488)__dbt_tmp being created as a permanent table, restore the transient config for Python materialized='table', and accept tmp_relation_type='table' for Python models. (#1928)data_type (#1510)<2.0 on dbt-core to prevent pip from resolving to dbt-core 2.0 (Fusion engine), which is incompatible with the python adapter (#2013)snowflake__generate_database_name reads catalog_database from the catalog relation via build_catalog_relation; when set it takes highest priority over
Use SHOW USER FUNCTIONS in list_function_relations_without_caching to filter built-in functions server-side; eliminates per-schema large-result chunke
<2.0 on dbt-core to prevent pip from resolving to dbt-core 2.0 (Fusion engine), which is incompatible with the python adapter (#2013)Add transient support for Snowflake dynamic tables via transient config option and snowflake_default_transient_dynamic_tables behavior flag.
transient config option and snowflake_default_transient_dynamic_tables behavior flag. (#716)iceberg_version config to enable Iceberg V3 table creation via model config or catalogs.yml adapter_properties. (#1779)tmp_relation_type=transient support for incremental models, enabling Snowflake lineage tracking; add snowflake__resolve_incremental_tmp_relation dispatch macro for controlling tmp relation destination (#1893)list_relations_without_caching to include function relations (#1488)__dbt_tmp being created as a permanent table, restore the transient config for Python materialized='table', and accept tmp_relation_type='table' for Python models. (#1928)data_type (#1510)When persist_docs.columns is enabled, dbt now warns about columns defined in YAML that don't exist in the database and filters them via the validate_d
__dbt_tmp being created as a permanent table, restore the transient config for Python materialized='table', and accept tmp_relation_type='table' for Python models. (#1928)Add transient support for Snowflake dynamic tables via transient config option and snowflake_default_transient_dynamic_tables behavior flag.
transient config option and snowflake_default_transient_dynamic_tables behavior flag. (#716)tmp_relation_type=transient support for incremental models, enabling Snowflake lineage tracking; add snowflake__resolve_incremental_tmp_relation dispatch macro for controlling tmp relation destination (#1893)Add cluster by config in Snowflake for dynamic tables
Bump dbt-core and dbt-adapters dependency
Add override of diff_column_data_types to preserve collation while altering column
Use a behavior flag to gate microbatch functionality (instead of an environment variable)
Log when underscores in Snowflake account names are replaced with hyphens.
Add support for UDF/UDAF default arguments
Allow partition_by model config for Snowflake Iceberg tables
Add cluster by config in Snowflake for dynamic tables
Support Iceberg REST with Catalog Linked Databases in Snowflake
Nothing published for this version
Nothing published for this version
fix issue where incorrect varchar size is applied for iceberg table columns
Preserve collation when altering a column size
## dbt-adapters 1.10.4 - November 11, 2024
## dbt-adapters 1.10.3 - October 29, 2024
dbt-tests-adapters: Add required begin to microbatch model config to BaseMicrobatch test
## dbt-adapters 1.10.1 - September 16, 2024
## dbt-adapters 1.10.0 - September 12, 2024
quoted_identifiers_ignore_case parameter to normalize snowflake metadata queries (#1159)Add support for optional iceberg builtin catalog relation parameters for data retention/extension, storage serialization & change tracking
quoted_identifiers_ignore_case parameter to normalize snowflake metadata queries (#1159)Add row_access_policy and table_tag config for Snowflake models
Set append=True as default query comment append behaviour
correct cluster_by type check to return str as-is
datetime.datetime.utcnow() is deprecated as of Python 3.12
iceberg_managed catalog type to built_in (#1011)datetime.datetime.utcnow() is deprecated as of Python 3.12 (#980)Added support for custom iceberg base_location_root
delete DDL (#1256)batch context variables over node.config.__dbt_internal ones (#1263)Nothing published for this version
Negate the check for microbatch behavior flag in determining builtins
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
dbt-adapters 1.8.0 - October 29, 2024
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Allows unique_key for snapshots to take a list
Enable setting current value of dbt_valid_to
Allow configuring of snapshot column names
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Your coding agent can read these notes before it upgrades. Set up the MCP server →