1.10.1

What's Changed

• 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
• Drop support for Python 3.8 and 3.9 by @jwills in #654
• Bump dbt-tests-adapter from 1.19.1 to 1.19.3 by @dependabot[bot] in #659
• Bump pyarrow from 21.0.0 to 22.0.0 by @dependabot[bot] in #652
• chore: fix and/or test slack notification by @elefeint in #661
• chore: use a unique database for each MotherDuck test run by @elefeint in #662
• Bump md duckdb to 1.4.2 by @jghoman in #666
• Bump actions/checkout from 5 to 6 by @dependabot[bot] in #664
• Bump dbt-tests-adapter from 1.19.3 to 1.19.4 by @dependabot[bot] in #665
• Bump sigstore/gh-action-sigstore-python from 3.1.0 to 3.2.0 by @dependabot[bot] in #669
• pin duckdb version for motherduck tests by @hrl20 in #671
• Bump actions/upload-artifact from 5 to 6 by @dependabot[bot] in #676
• Bump dbt-tests-adapter from 1.19.4 to 1.19.5 by @dependabot[bot] in #674
• Bump actions/download-artifact from 6 to 7 by @dependabot[bot] in #675
• Log duckdb Error Message by @Tseegi-N in #677
• Fix transaction commit error when no upstream external models exist (Fixes #678) by @jwills in #679
• Update pre-commit hooks by @yu-iskw in #683
• fix: rollback transaction in exception handler by @hfrifkin in #684
• Microbatch alternative by @dumkydewilde in #681
• pin pandas version for tests by @hrl20 in #689
• bump duckdb and pandas dev dependencies by @hrl20 in #692
• Bump pyarrow from 22.0.0 to 23.0.0 by @dependabot[bot] in #688

New Contributors

• @jghoman made their first contribution in #666
• @Tseegi-N made their first contribution in #677
• @yu-iskw made their first contribution in #683
• @hfrifkin made their first contribution in #684

Full Changelog: 1.10.0...1.10.1

1.10.0

What's Changed

• Fix for attach test failures in nightly by @jwills in #631
• DuckLake connection instructions by @matsonj in #632
• Bump mypy from 1.17.1 to 1.18.1 by @dependabot[bot] in #633
• Fix excel plugin skip_empty_sheets by @JCotton1123 in #635
• Add Python 3.13 support in CI and metadata by @jwills in #634
• Break out create temp schema into its own transaction by @hrl20 in #638
• Bump mypy from 1.18.1 to 1.18.2 by @dependabot[bot] in #637
• Bump dbt-tests-adapter from 1.18.0 to 1.19.1 by @dependabot[bot] in #642
• Add slack notification on CI failure by @elefeint in #643
• Bump slackapi/slack-github-action from 2.0.0 to 2.1.1 by @dependabot[bot] in #645
• Bump actions/upload-artifact from 4 to 5 by @dependabot[bot] in #649
• Bump sigstore/gh-action-sigstore-python from 3.0.1 to 3.1.0 by @dependabot[bot] in #651
• Bump actions/download-artifact from 5 to 6 by @dependabot[bot] in #650
• Add MERGE incremental strategy with DuckDB extensions support by @VahOkan in #605
• Update MotherDuck duckdb pin to 1.4.1 by @jwills in #653

New Contributors

• @elefeint made their first contribution in #643
• @VahOkan made their first contribution in #605

Full Changelog: 1.9.6...1.10.0

1.9.6

What's Changed

• Remove extraneous log() lines for index-related operations by @jwills in #630

Full Changelog: 1.9.5...1.9.6

1.9.5

What's Changed

• Bump sigstore/gh-action-sigstore-python from 3.0.0 to 3.0.1 by @dependabot[bot] in #583
• Bump mypy from 1.16.0 to 1.16.1 by @dependabot[bot] in #582
• Make the adapter.commit call inside of upstream.sql dependent on upstream_nodes existing by @jwills in #588
• Fix incremental Python models on MotherDuck by @hiddestokvis in #591
• Bump freezegun from 1.5.2 to 1.5.3 by @dependabot[bot] in #595
• Bump pyarrow from 18.1.0 to 21.0.0 by @dependabot[bot] in #598
• Add struct column support with flatten functionality by @jwills in #594
• Bump mypy from 1.16.1 to 1.17.0 by @dependabot[bot] in #597
• Bump dbt-tests-adapter from 1.16.0 to 1.17.0 by @dependabot[bot] in #602
• Bump mypy from 1.17.0 to 1.17.1 by @dependabot[bot] in #604
• Bump actions/download-artifact from 4 to 5 by @dependabot[bot] in #606
• Bump freezegun from 1.5.3 to 1.5.5 by @dependabot[bot] in #607
• Fix secrets map/list type handling in DuckDB SQL generation by @jwills in #609
• Bump actions/checkout from 4 to 5 by @dependabot[bot] in #610
• Fix orchestrator compatibility: change logger.exception to logger.warning by @jwills in #612
• Update excel plugin to filter all null rows by @JCotton1123 in #615
• Bump dbt-tests-adapter from 1.17.0 to 1.18.0 by @dependabot[bot] in #613
• tests: support DuckDB nightly IOException import by @jwills in #618
• Add "type: ducklake" support for managed DuckLake by @matsonj in #620
• Display traceback when Python model raises exception by @thomas-daniels in #621
• duckdb: fix dateadd interval syntax for newer DuckDB versions by @jwills in #624
• Support ducklake database in primary database and add is_ducklake flag to identify motherduck managed ducklake by @hrl20 in #625
• do ATTACH IF NOT EXISTS for attachments by @hrl20 in #626
• An updated version of the code to add support for indexes to dbt-duckdb by @jwills in #522
• Bump actions/setup-python from 5 to 6 by @dependabot[bot] in #628
• bump duckdb to 1.3.2 by @hrl20 in #629

New Contributors

• @hiddestokvis made their first contribution in #591
• @thomas-daniels made their first contribution in #621

Full Changelog: 1.9.4...1.9.5

1.9.4

What's Changed

• Bump dbt-tests-adapter from 1.11.0 to 1.15.0 by @dependabot in #549
• Apply project quoting setting to add/remove columns by @gregwdata in #548
• Add named secret parameter to attachment class for profiles.yml by @dumkydewilde in #550
• Read .duckdbrc file on DuckDBT CLI startup by @elephantmetropolis in #553
• See if this is related to the mysterious doc test failures that popped up on master by @jwills in #554
• Bump freezegun from 1.5.1 to 1.5.2 by @dependabot in #555
• Add support for arbitrary key-value pairs in Attachment ATTACH options by @jwills in #556
• Update macros for dropping schema and relations when using ducklake by @wideltann in #557
• Bump dbt-tests-adapter from 1.15.0 to 1.15.1 by @dependabot in #562
• Bump mypy from 1.15.0 to 1.16.0 by @dependabot in #561
• FIX: Fixes issue caused by external materializations with column name contains spaces by @tcboles in #563
• Fix attachment option quoting to prevent SQL errors with path-like values by @jwills in #566
• Bump dbt-tests-adapter from 1.15.1 to 1.16.0 by @dependabot in #570
• Assume native comment support in DuckDB catalog queries by @jwills in #571
• Fix bug where schema's database not specified by @tehunter in #577
• Fix error swallowing that hides DuckDB exception details by @jwills in #579
• bump duckdb to 1.3.1 by @hrl20 in #585
• fix write conflict when first creating dbt_temp schema by @hrl20 in #584

New Contributors

• @gregwdata made their first contribution in #548
• @wideltann made their first contribution in #557
• @tcboles made their first contribution in #563

Full Changelog: 1.9.3...1.9.4

1.9.3

What's Changed

• Fix: external materialization strategy adding extra newlines to logs by @guenp in #517
• Vibe-claudeing a duckdbt CLI by @jwills in #520
• Add fzf-based model autocomplete to duckdbt by @jwills in #524
• table_function materialization (skip view recreate on schema change) by @Alex-Monahan in #525
• Add support for scoped secrets/credentials by storage prefix by @01100100 in #530
• Support dbt_valid_to_current for snapshots by @jwills in #529
• Update README.md to clarify DuckDB file path behavior and automatic database creation by @matsonj in #536
• Fix: turn txns back on for MD by @guenp in #540
• Remove duckdbt entrypoint for now by @guenp in #541
• Bump duckdb version to v1.2.2, patch unit test for MotherDuck truncated error message by @guenp in #542
• Add info on the interactive shell for the DuckDB UI to the README by @jwills in #543

New Contributors

• @Alex-Monahan made their first contribution in #525
• @01100100 made their first contribution in #530

Full Changelog: 1.9.2...1.9.3

1.9.2

What's Changed

• Use tmpdir_factory instead of tmp_path_factory to see if it helps fix flaky file-based test by @guenp in #483
• Bump GitHub actions versions by @guenp in #486
• Fix bug in GitHub release yml by @guenp in #489
• Drop Python 3.8 support, add 3.12 by @guenp in #490
• Fix out of date README comment about version support for dbt-core and duckdb by @jwills in #487
• add support for per_thread_output in external materialization by @elephantmetropolis in #493
• Run tests with DuckDB nightly release every 24h by @guenp in #497
• Bump mypy from 1.13.0 to 1.14.1 by @dependabot in #495
• Remove package build/test build steps by @guenp in #498
• Make keep_open: true the default setting for dbt-duckdb going forward by @jwills in #502
• Update deprecated v3 -> v4 for upload-artifact and download-artifact by @jwills in #507
• [Fix] External materialization to S3 does not work if table is empty by @guenp in #510
• skip s3 tests if the secrets are not available by @guenp in #511
• Bump mypy from 1.14.1 to 1.15.0 by @dependabot in #508
• Bump dbt-tests-adapter from 1.10.4 to 1.11.0 by @dependabot in #509

New Contributors

• @elephantmetropolis made their first contribution in #493

Full Changelog: 1.9.1...1.9.2

1.9.1

What's Changed

• Support HTTP secret extra_http_headers by @dvic in #456
• Linting fixes for PR #456 by @jwills in #460
• Make grant configs a no-op for DuckDB by @jwills in #459
• Update to Buena Vista 0.5.0 by @jwills in #462
• adding transaction support in md by @matsonj in #463
• Added basic AWS Glue struct datatype support and JSON/CSV/PARQUET read_options by @firewall413 in #464
• Move the secret creation to a connection-level operation instead of a cursor-level operation by @jwills in #468
• Add safety check for node in graph by @tehunter in #472
• Document Postgres attachment for read/write by @dumkydewilde in #476
• Bump dbt-tests-adapter from 1.10.2 to 1.10.3 by @dependabot in #474
• Bump mypy from 1.11.2 to 1.13.0 by @dependabot in #471
• Bump dbt-tests-adapter from 1.10.3 to 1.10.4 by @dependabot in #477
• Remove mention of outdated MotherDuck constraints in Readme by @Flogex in #470
• Update Postgres Plugin for dbt-duckdb to Use ATTACH Syntax and Improve Compatibility Gexar/update pgsql plugin #478 by @Gexar in #480
• Add unique UUID to temp table name to run incremental models concurrently by @guenp in #482

New Contributors

• @dvic made their first contribution in #456
• @matsonj made their first contribution in #463
• @tehunter made their first contribution in #472
• @dumkydewilde made their first contribution in #476
• @Flogex made their first contribution in #470
• @Gexar made their first contribution in #480

Full Changelog: 1.9.0...1.9.1

1.9.0

What's Changed

• Fix Excel logger in dbt-core 1.9.0 by @edgarrmondragon in #449
• (fix) dbt-adapters 1.9.0 fix for MD pre and post-model hooks by @guenp in #451
• Add support for configuring community/nightly extensions in the profile directly by @jwills in #450
• (fix) generate_database_name macro should be case insensitive by @guenp in #453
• Bump dbt-tests-adapter from 1.9.2 to 1.10.2 by @dependabot in #454

New Contributors

• @edgarrmondragon made their first contribution in #449

Full Changelog: 1.8.4...1.9.0

1.8.4

What's Changed

• author-email -> author_email by @jwills in #428
• Bump mypy from 1.11.1 to 1.11.2 by @dependabot in #430
• Disable Python models on MotherDuck when SaaS mode is on by @guenp in #435
• support preleases by @mrjsj in #438
• Remove deprecated DeltaLake functions by @guenp in #439
• Pass credentials to Glue plugin constructor by @guenp in #436
• Fixes to dbt-duckdb to work with DuckDB 1.1.0 by @jwills in #440
• (fix) Add support for attaching a MotherDuck database with token in settings or config by @guenp in #444
• (fix): MotherDuck config should set SaaS mode at the end by @guenp in #446
• Updates for dbt-duckdb 1.8.4 by @jwills in #447

New Contributors

• @mrjsj made their first contribution in #438

Full Changelog: 1.8.3...1.8.4