Is there a way to pin DuckDB version?

[ldolberg]

By default it loads the latest, 1.2.0,
I'm wondering if possible to use previous builds?
Thanks in advance

[jwills]

yeah of course, lots of ways to do this in python-- virtual environments, requirements.txt files, etc., etc.

https://emmer.dev/blog/quickly-pin-python-package-versions/

or just google/chatgpt "pin python dependencies"

[ldolberg]

Hey @jwills I guess my question wasn´t properly redacted, my apologies for that.
I do have the dependencies pinned.

dbt-core==1.8.6
dbt-duckdb==1.8.3
dbt-extractor==0.5.1
dbt-postgres==1.8.2
duckdb==1.1.0

However, when running a dbt model with duck in a dagster asset seems it runs 1.20. as far as I can tell from this error

The file was built specifically for DuckDB version '1b8c9023d0' and can only be loaded with that version of DuckDB. (this version of DuckDB is 'v1.2.0')