1.6.0

What's Changed

• Fix whatever is going on with the MD integration tests by @jwills in #199
• Bump mypy from 1.3.0 to 1.4.1 by @dependabot in #197
• Bump dbt-tests-adapter from 1.5.1 to 1.5.2 by @dependabot in #198
• Disable these tests on MD and add a note to the README by @jwills in #201
• Add more detailed checks to ensure consistent settings between the path and database by @jwills in #196
• Check and reset the environment for a DuckDB connection if the credentials have changed by @jwills in #204
• Make it nicer to run the functional adapter tests on OS X by @jwills in #205
• Simplify some setup stuff now that Python 3.7 is EOL'd by @jwills in #206
• Updates to support the revamped dbt debug command in 1.6.0 by @jwills in #207
• Add in plugins for the motherduck and postgres extensions by @jwills in #208
• Add a keep_open option to the profile by @jwills in #210
• Require duckdb >= 0.7.0 for dbt-duckdb going forward and remove some code... by @jwills in #212
• fix: remove parenthesis from md_connect call by @gmontanola in #214
• Try to fix the MD integration test configs by @jwills in #221
• Bump black from 23.3.0 to 23.7.0 by @dependabot in #215
• Bump dbt-tests-adapter from 1.5.2 to 1.5.4 by @dependabot in #220
• Make fast seed loading the default by @jwills in #222
• Add an option to the profile for specifying additional entries for sys.path by @jwills in #223
• Prep for dbt-duckdb 1.6.0 release by @jwills in #224
• Update README for 1.6.0 by @jwills in #225

New Contributors

• @gmontanola made their first contribution in #214

Full Changelog: 1.5.2...1.6.0

1.5.2

What's Changed

• Prepping the dbt-duckdb tests to pass under the next release of DuckDB by @jwills in #166
• For the remote.password stuff to work we need to use it with psycopg2.connect by @jwills in #167
• Bump mypy from 1.2.0 to 1.3.0 by @dependabot in #168
• Add a fast-path option for loading dbt's seed files via a DuckDB COPY operation by @jwills in #169
• Revamp the plugins setup to support configuring the DuckDBPyConnection instance directly by @jwills in #171
• Some fixes for catalog lookups in a multi-database, multi-schema world by @jwills in #172
• Bump dbt-tests-adapter from 1.5.0 to 1.5.1 by @dependabot in #175
• Create a simple plugin system for writing data to external destinations by @jwills in #173
• Prevent loading source data via plugin during dbt parsing phase by @AlexanderVR in #178
• Simplify extension loading in dbt-duckdb by @jwills in #180
• Updates to support a broader class of incremental functionality by @jwills in #181
• Prep for Python 3.7 EOL by @jwills in #182
• Updates for working with MotherDuck databases by @jwills in #183
• Automatically disable transactions on motherduck paths by @jwills in #186
• Add an example of doing a write-side operation in the sqlalchemy plugin by @jwills in #187
• Support alternate string formatting strategies for external sources by @jwills in #188
• Disable this test for now while DuckDB issue 7934 gets worked out by @jwills in #189
• Add in MotherDuck docs and do a version bump by @jwills in #190
• Document the Plugin.store functionality in the README by @jwills in #191

Full Changelog: 1.5.1...1.5.2

1.5.1

What's Changed

• Use info from the source.config and source.table.config entries for external data by @jwills in #154
• Support profiles that are simply 'type: duckdb' by correctly configuring the in-memory db setup by @jwills in #159
• Set a default value for the conn attribute in the case an exception is thrown during init by @jwills in #160
• Have the local environment release the connection when it's not in use by @jwills in #163
• pyarrow should not be required to run dbt-duckdb python models by @jwills in #164

Full Changelog: 1.5.0...1.5.1

dbt-duckdb 1.5.0

Updated for dbt-core 1.5.0 with support for model contracts

What's Changed

• Add support for model contracts in v1.5 by @jtcohen6 in #148
• Prep work for 1.5.0 by @jwills in #146
• Smarter handling of the profile path argument by @jwills in #152
• Do the 1.5.0 release by @jwills in #153

New Contributors

• @jtcohen6 made their first contribution in #148

Full Changelog: 1.4.2...1.5.0

dbt-duckdb 1.4.2

What's Changed

• Refactor the code in the connections module into the credentials and environments modules by @jwills in #123
• Upstream model registration redux by @AlexanderVR in #126
• Run every functional test in multithreaded mode by default by @jwills in #129
• add format to fix glue registration bug by @N-Clerkx in #133
• Inject any key-value pairs from the meta dictionary into the f-string context for external locations by @jwills in #130
• Enable testing with file DB and fix bug in connection handling by @vlieven in #131
• Wire up GH Actions to run file-based tests as well as in-memory tests on PRs by @jwills in #134
• Adds a remote environment for DuckDB databases running in a Buena Vista server by @jwills in #135
• only return non-empty creds to prevent code 400 when session token is empty by @N-Clerkx in #138
• Bump black from 22.12.0 to 23.3.0 by @dependabot in #136
• Set unique_field in credentials.py by @aranke in #140
• Bump mypy from 1.1.1 to 1.2.0 by @dependabot in #142
• Create a simple plugin system for loading data from external sources by @jwills in #141
• Enable additional iceberg config options + and add a Spark-style save_mode option for plugins by @jwills in #144
• Bump dbt-tests-adapter from 1.4.5 to 1.4.6 by @dependabot in #149
• Doing a 1.4.2 release to pickup bug fixes ahead of the 1.5.0 cutover by @jwills in #151

New Contributors

• @N-Clerkx made their first contribution in #133
• @vlieven made their first contribution in #131
• @aranke made their first contribution in #140

Full Changelog: 1.4.1...1.4.2

dbt-duckdb 1.4.1

• Adds support for filesystems
• Added support for arbitrary options to pass to the DuckDB COPY operation that powers external materializations
• Bug fixes and (sorely needed) documentation updates

dbt-duckdb 1.4.0

Adds support for DuckDB 0.7.0, attachable databases, and squashes a number of bugs

v1.3.1

What's Changed

• fix: add functional test from 1.3.0 by @tomsej in #32
• feat: python model by @tomsej in #28
• style: fix missing import ordering by @tomsej in #36
• feat: add dependabot by @tomsej in #39
• fix: development env requirements by @AlexanderVR in #37
• Bump actions/download-artifact from 2 to 3 by @dependabot in #40
• Bump freezegun from 0.3.12 to 1.2.2 by @dependabot in #41
• fix: concurrency tests by @AlexanderVR in #38
• feat: add support for external materialization by @tomsej in #35
• Add external location macro by @tomsej in #44
• fix: remove unused macro create_view_loacation by @tomsej in #45
• fix: default delimiter changed to comma by @tomsej in #48
• feat: external_root profile setting as dir to write external tables when no location is specified by @jwills in #49
• feat: add support for glue catalog by @tomsej in #47
• feat: external_location meta propery for sources @jwills in #46
• Docs update for the 1.3.0 release by @jwills in #50
• fix: disable upgrading pip in github action by @tomsej in #52
• Fix upgrading pip by @tomsej in #53
• fix: run external everytime by @tomsej in #51
• Bump to 1.3.1 and release that by @jwills in #54

New Contributors

• @AlexanderVR made their first contribution in #37
• @dependabot made their first contribution in #40

Full Changelog: v1.2.3...v1.3.1

v1.2.3

What's Changed

• feat: adapt to scaffolding template by @tomsej in #29
• Ensure that we always keep a connection open when we're running dbt-duckdb in memory by @jwills in #31

Full Changelog: https://github.com/jwills/dbt-duckdb/commits/v1.2.3