1.7.1

What's Changed

• Update README.md by @jwills in #287
• Add support for providing additional kwargs for sqlalchemy connection by @amaralvieira in #290
• Bump mypy from 1.6.1 to 1.7.0 by @dependabot in #292
• Bump black from 23.10.1 to 23.11.0 by @dependabot in #293
• Bump dbt-tests-adapter from 1.7.0 to 1.7.1 by @dependabot in #294
• Bump dbt-tests-adapter from 1.7.1 to 1.7.2 by @dependabot in #296
• Bump mypy from 1.7.0 to 1.7.1 by @dependabot in #297
• Fix sqlite write by @Nintorac in #299
• Bump freezegun from 1.2.2 to 1.3.0 by @dependabot in #301
• Bump dbt-tests-adapter from 1.7.2 to 1.7.3 by @dependabot in #302
• Move from black/flake to ruff and fix the stuff ruff found by @jwills in #303
• Update is_integer and is_float for DuckDB integer/float types by @jwills in #305
• Bump actions/setup-python from 4 to 5 by @dependabot in #307
• Bump freezegun from 1.3.0 to 1.3.1 by @dependabot in #306
• Bump version supported by MotherDuck in README by @mehd-io in #308
• Bump dbt-tests-adapter from 1.7.3 to 1.7.4 by @dependabot in #311
• Add support for retrying certain types of exceptions we see when running models with DuckDB by @jwills in #298
• Bump freezegun from 1.3.1 to 1.4.0 by @dependabot in #315
• Bump mypy from 1.7.1 to 1.8.0 by @dependabot in #316

New Contributors

• @amaralvieira made their first contribution in #290
• @Nintorac made their first contribution in #299
• @mehd-io made their first contribution in #308

Full Changelog: 1.7.0...1.7.1

1.7.0

What's Changed

• Bump black from 23.10.0 to 23.10.1 by @dependabot in #285
• Prep work for dbt-core 1.7.0 by @jwills in #280

Full Changelog: 1.6.2...1.7.0

1.6.2

What's Changed

• Re-enable returning a temp table in python models by @AlexanderVR in #272
• Bump mypy from 1.5.1 to 1.6.0 by @dependabot in #273
• Bump dbt-tests-adapter from 1.6.5 to 1.6.6 by @dependabot in #274
• Update Excel plugin with output support by @JCotton1123 in #260
• Update README with latest target DuckDB version by @jwills in #275
• Bump MotherDuck's version requirement by @szarnyasg in #277
• Bump black from 23.9.1 to 23.10.0 by @dependabot in #278
• Bump mypy from 1.6.0 to 1.6.1 by @dependabot in #279
• feat: support reading delta tables with delta plugin by @milicevica23 in #263
• update delta readme by @milicevica23 in #282
• Prep and cut a 1.6.2 release by @jwills in #283

New Contributors

• @JCotton1123 made their first contribution in #260
• @szarnyasg made their first contribution in #277
• @milicevica23 made their first contribution in #263

Full Changelog: 1.6.1...1.6.2

1.6.1

What's Changed

• Make source tags available to plugins through the SourceConfig by @AlexanderVR in #228
• Add s3 support to Excel plugin through env variables by @felippecaso in #230
• Update the docs to point at the macro that controls the default location for external materializations by @jwills in #231
• Add option to fetch Gsheet data using range by @Thootje in #233
• Bump mypy from 1.4.1 to 1.5.0 by @dependabot in #234
• Update README.md by @jwills in #235
• Bump mypy from 1.5.0 to 1.5.1 by @dependabot in #239
• Bump dbt-tests-adapter from 1.6.0 to 1.6.1 by @dependabot in #240
• Pin pandas depenedency to 2.0.0 to get around dtypes error in integration tests by @jwills in #246
• Bump actions/checkout from 3 to 4 by @dependabot in #243
• Bump black from 23.7.0 to 23.9.1 by @dependabot in #244
• See if I can isolate whatever issue is springing up with the MD integration tests by @jwills in #247
• Add a maxfail arg to the MD pytest runs so they fail quickly by @jwills in #248
• Bump dbt-tests-adapter from 1.6.1 to 1.6.2 by @dependabot in #245
• Add a more helpful error message in the case that the options argument isn't a dictionary by @jwills in #250
• Fix typos and formatting issues in dbt-duckdb README documentation by @thfmn in #253
• Refactor render_write_options for direct option rendering by @thfmn in #254
• Allow access to the RuntimeConfigObject from the TargetConfig by @jwills in #256
• Bump dbt-tests-adapter from 1.6.2 to 1.6.3 by @dependabot in #258
• Relaxing the Pandas dev requirement now that 0.9.0 is out the door by @jwills in #261
• Add a sample_profiles.yml file for dbt-duckdb by @jwills in #262
• Bump dbt-tests-adapter from 1.6.3 to 1.6.4 by @dependabot in #264
• Bump dbt-tests-adapter from 1.6.4 to 1.6.5 by @dependabot in #267
• Enable batch processing on Python models by @droher in #269
• Fix cursor isolation on Python model by @droher in #270
• Prep for 1.6.1 release by @jwills in #271

New Contributors

• @felippecaso made their first contribution in #230
• @Thootje made their first contribution in #233
• @thfmn made their first contribution in #253

Full Changelog: 1.6.0...1.6.1

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