NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI · #2969 most downloaded on PyPI
The duckdb adapter plugin for dbt (data build tool)
Last release 1 months ago
07 Aug 2026
Ships fairly regularly
a new release about every 2 months
Most releases are documented
notes for 41 of 47 stable releases
1 version withdrawn
withdrawn after publishing
6 years old
49 releases · first in 2020
One column per quarter.
ci: replace deprecated set-output, add pip caching, shift nightly cron by @arijitroy003 in #794
Behavior change: partitioned_by/partition_by entries are now emitted in the compiled SQL as written instead of being
quoted as identifiers, so partition column names containing space or special characters may break. Quote names yourself if needed, e.g. partitioned_by=['column with space', 'region'] -> partitioned_by=['"column with space"', 'region'].
Full Changelog: 1.10.1...1.11.0
pin logbook below 1.9 b/c pytest-logbook still relies on the compat module which was removed in logbook 1.9.x by @jwills in #656
Full Changelog: 1.10.0...1.10.1
Fix for attach test failures in nightly by @jwills in #631
Full Changelog: 1.9.6...1.10.0
skip_empty_sheets handlingRemove extraneous log() lines for index-related operations by @jwills in #630
Full Changelog: 1.9.5...1.9.6
Bump sigstore/gh-action-sigstore-python from 3.0.0 to 3.0.1 by @dependabot [bot] in #583
upstream_nodes existing by @jwills in #588Full Changelog: 1.9.4...1.9.5
dateadd interval syntax for newer DuckDB versionsBump dbt-tests-adapter from 1.11.0 to 1.15.0 by @dependabot in #549
Full Changelog: 1.9.3...1.9.4
dbt_temp schemaFix: external materialization strategy adding extra newlines to logs by @guenp in #517
Full Changelog: 1.9.2...1.9.3
table_function materialization (skip view recreate on schema change)dbt_valid_to_current support for snapshotsUpdate deprecated v3 -> v4 for upload-artifact and download-artifact by @jwills in #507
Full Changelog: 1.9.1...1.9.2
keep_open: true the default settingper_thread_output in external materializationSupport HTTP secret extra_http_headers by @dvic in #456
Full Changelog: 1.9.0...1.9.1
extra_http_headers supportFix Excel logger in dbt-core 1.9.0 by @edgarrmondragon in #449
Full Changelog: 1.8.4...1.9.0
generate_database_name macro to be case insensitiveRemove deprecated DeltaLake functions by @guenp in https://github.com/duckdb/dbt-duckdb/pull/439
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.8.3...1.8.4
fix(secrets): value should be enclosed in quotes by @waaronmorris in https://github.com/duckdb/dbt-duckdb/pull/421
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.8.2...1.8.3
_Note: We deprecated the old AWS credentials chain setup and replaced it with one based on the DuckDB Secrets Manager_
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.8.1...1.8.2
Bump freezegun from 1.5.0 to 1.5.1 by @dependabot in https://github.com/duckdb/dbt-duckdb/pull/397
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.8.0...1.8.1
Migrate to dbt-common + dbt-adapters by @jtcohen6 in https://github.com/duckdb/dbt-duckdb/pull/342
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.7.5...1.8.0
query cancellation attempt by @hrl20 in https://github.com/duckdb/dbt-duckdb/pull/383
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.7.4...1.7.5
profile_name to boto3 Session for AWS credential configurationBump mypy from 1.8.0 to 1.9.0 by @dependabot in https://github.com/duckdb/dbt-duckdb/pull/359
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.7.3...1.7.4
persist_docs functionalityUpdate dateadd to work with new datediff by @b-per in https://github.com/duckdb/dbt-duckdb/pull/347
dateadd to work with new datediff by @b-per in https://github.com/duckdb/dbt-duckdb/pull/347Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.7.2...1.7.3
dateadd macro to work with updated datediffcustom_user_agent to run after connectcustom_user_agent when MotherDuck plugin is not specified in profiles.ymlAdd note about incremental materialization strategies by @jwills in https://github.com/duckdb/dbt-duckdb/pull/322
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.7.1...1.7.2
custom_user_agent to MotherDuck connection configdate_diff function for the datediff macroUpdate README.md by @jwills in https://github.com/duckdb/dbt-duckdb/pull/287
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.7.0...1.7.1
is_integer and is_float for DuckDB integer/float typesBump black from 23.10.0 to 23.10.1 by @dependabot in https://github.com/duckdb/dbt-duckdb/pull/285
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.6.2...1.7.0
Re-enable returning a temp table in python models by @AlexanderVR in https://github.com/duckdb/dbt-duckdb/pull/272
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.6.1...1.6.2
Make source tags available to plugins through the SourceConfig by @AlexanderVR in https://github.com/duckdb/dbt-duckdb/pull/228
Full Changelog: https://github.com/duckdb/dbt-duckdb/compare/1.6.0...1.6.1
Fix whatever is going on with the MD integration tests by @jwills in https://github.com/jwills/dbt-duckdb/pull/199
Full Changelog: https://github.com/jwills/dbt-duckdb/compare/1.5.2...1.6.0
dbt debug command supportkeep_open option to the profilemodule_path option for specifying additional sys.path entriesPrepping the dbt-duckdb tests to pass under the next release of DuckDB by @jwills in https://github.com/jwills/dbt-duckdb/pull/166
Full Changelog: https://github.com/jwills/dbt-duckdb/compare/1.5.1...1.5.2
Use info from the source.config and source.table.config entries for external data by @jwills in https://github.com/jwills/dbt-duckdb/pull/154
source.config and source.table.config entries for external data by @jwills in https://github.com/jwills/dbt-duckdb/pull/154Full Changelog: https://github.com/jwills/dbt-duckdb/compare/1.5.0...1.5.1
source.config entries for external datatype: duckdb only)Updated for dbt-core 1.5.0 with support for model contracts
Updated for dbt-core 1.5.0 with support for model contracts
path argument by @jwills in https://github.com/jwills/dbt-duckdb/pull/152Full Changelog: https://github.com/jwills/dbt-duckdb/compare/1.4.2...1.5.0
path argumentNothing published for this version
Refactor the code in the connections module into the credentials and environments modules by @jwills in https://github.com/jwills/dbt-duckdb/pull/123
connections module into the credentials and environments modules by @jwills in https://github.com/jwills/dbt-duckdb/pull/123meta dictionary into the f-string context for external locations by @jwills in https://github.com/jwills/dbt-duckdb/pull/130Full Changelog: https://github.com/jwills/dbt-duckdb/compare/1.4.1...1.4.2
connections module into credentials and environments modulessave_mode for pluginsmeta dictionary key-value pairs into f-string context for external locationsAdded support for arbitrary options to pass to the DuckDB COPY operation that powers external materializations
options to pass to the DuckDB COPY operation that powers external materializationsoptions to pass to DuckDB COPY for external materializationsAdds support for DuckDB 0.7.0, attachable databases, and squashes a number of bugs
Adds support for DuckDB 0.7.0, attachable databases, and squashes a number of bugs
ATTACH additional databasesNothing published for this version
Nothing published for this version
- Added support for DuckDB 0.6.x
fix: add functional test from 1.3.0 by @tomsej in https://github.com/jwills/dbt-duckdb/pull/32
external_root profile setting as dir to write external tables when no location is specified by @jwills in https://github.com/jwills/dbt-duckdb/pull/49Full Changelog: https://github.com/jwills/dbt-duckdb/compare/v1.2.3...v1.3.1
external materialization typeNothing published for this version
feat: adapt to scaffolding template by @tomsej in https://github.com/jwills/dbt-duckdb/pull/29
Full Changelog: https://github.com/jwills/dbt-duckdb/commits/v1.2.3
settings dictionary for configuring arbitrary settings in the DuckDB
instance used during the dbt runFixed a small bug in the multithreading implementation
Added support for multi-threaded dbt-duckdb runs
Support for loading DuckDB extensions
Enforces the single-thread limit on the dbt-duckdb profile
Fixes DuckDB 0.4.0 compatibility issue
Align with minor version of dbt-core
Fix typo in package description
Refactored adapter so that dbt threads > 1 work with DuckDB
Nothing published for this version
Nothing published for this version
First basically working version
Nothing published for this version
Your coding agent can read these notes before it upgrades. Set up the MCP server →