Guen P.

Posted in Announcements·

Guen P.

We just released a new version of dbt-duckdb! :du...

We just released a new version of dbt-duckdb! The latest version is 1.9.3 and includes:

A new experimental duckdb UI + dbt interactive shell tool (aka duckdbt) by @jwills ( #520 + #524 + 543 ), that lets you use the DuckDB UI while running dbt CLI commands! Check out the instructions how to use it here.
Several fixes by @guenp: remove extra newlines in logs #517, remove dangling commit; from run_hooks macro #539, turn txns back on by default for MD #540, Bump duckdb version to v1.2.2 #542
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

Thank you Alex M. and Dave Whittingham for being first-time contributors!

0Comments

Posted in Announcements·

Guen P.

New ODBC Driver Releases for Power BI Users with Bug Fixes

Great news for Power BI users -- there are now minor patch releases on the ODBC driver (for example, v1.2.2.x, where the first three version numbers are the same as DuckDB core). This means that you'll be able to download the driver with critical bug fixes in between DuckDB releases 🎉 and it will be built using the latest released version of DuckDB, so you can use it with Power BI and MotherDuck! The most recent release is here: https://github.com/duckdb/duckdb-odbc/releases/tag/v1.2.2.2

0Comments

Posted in Announcements·

Guen P.

🚀 We just released a new version of dbt-duckdb! The latest version is...

🚀 We just released a new version of dbt-duckdb! The latest version is 1.9.2. Here's some highlights -- you can find the full release notes here.

add support for per_thread_output in external materialization by @elephantmetropolis in #493
Make keep_open: true the default setting for dbt-duckdb going forward by @jwills in #502
[Fix] External materialization to S3 does not work if table is empty by @guenp in #510

0Comments

Posted in Announcements·

Guen P.

We just released a new version of `dbt-duckdb`! The latest ve...

🚀 We just released a new version of dbt-duckdb! The latest version is 1.9.1. This new version contains a good amount of bugfixes and improvements. You can find the full release notes here.

0Comments

Commented on Performance Comparison: Local DuckDB vs MotherDuck...·Posted inGeneral

Guen P.

Sounds great! Ping Leonardo V.

Commented on Performance Comparison: Local DuckDB vs MotherDuck...·Posted inGeneral

Guen P.

Hi Alexander 👋 thank you for trying out MotherDuck! We're happy to help you optimize your pipelines to see the best possible performance. Can one of our engineers on the team reach out to you via DM to set up a time to chat? To answer your question, there are multiple reasons you could be seeing a slowdown. I'd recommend taking a look at these docs for some Best Practices for connecting to MotherDuck with Python: https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/connecting-to-motherduck/

Posted in General·

Guen P.

New dbt-duckdb 1.9.0 Release: Key Fixes and Features Added

🚀 New dbt-duckdb release was just pushed to PyPI! The latest version is 1.9.0.

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

1Comment

Posted in General·

Guen P.

New Release: dbt-duckdb 1.8.4 with Exciting Features and Bug Fixes

🚀 We just released a new version of dbt-duckdb! The new version is 1.8.4. See release notes here. The changes for this release:

support preleases by @mrjsj in #438
Several bug fixes by @guenp in #436 and #439
Add support for DuckDB 1.1.0 by @jwills in #440
Add support for attaching a MotherDuck database with token in settings or config by @guenp in #444
Several fixes for MotherDuck SaaS mode by @guenp in #446 and #435
Fix constraint rendering for foreign keys by @jwills in #447

0Comments

Commented on Troubleshooting Motherduck's Access to Azure Funct...·Posted inGeneral

Guen P.

Hmm, this does seem to work:

SELECT * FROM read_json('https://dummyjson.com/product');

So it should work with API endpoints! I am not sure why it's not working with yours.

Commented on Troubleshooting Motherduck's Access to Azure Funct...·Posted inGeneral

Guen P.

If you are feeling like starting a coding project, you can look at these ecosystem tools that let you load data from an API endpoint into DuckDB: https://dlthub.com/docs/pipelines/rest_api/load-data-with-python-from-rest_api-to-duckdb https://airbyte.com/how-to-sync/public-api-to-duckdb

About

Start Date
Title