Runtime Error: `duckdb.duckdb_extension` Extension missing or invalid
jagrafft opened this issue ยท 4 comments
jagrafft commented
dbt run
throws a runtime error saying the extension duckdb.duckdb_extension
cannot be loaded from ${env:HOMEPATH}\.duckdb\extensions\v0.9.2\windows_amd64\
. Happens in all cases, and https://duckdb.org/docs/extensions/overview does not list an md
extension.
System
- Windows 10 Enterprise
- DuckDB
v0.9.2 3c695d7ba9
(winget install) - Poetry virtual environment
- Python
3.11.6
Error Message
22:43:57 Running with dbt=1.7.7
22:43:57 Checking ${env:HOMEPATH}\dev\python\duckdb-dbt-demo\dbt_packages/*
22:43:57 Cleaned ${env:HOMEPATH}\dev\python\duckdb-dbt-demo\dbt_packages/*
22:43:57 Checking ${env:HOMEPATH}\dev\python\duckdb-dbt-demo\target/*
22:43:57 Cleaned ${env:HOMEPATH}\dev\python\duckdb-dbt-demo\target/*
22:43:57 Finished cleaning all paths.
22:44:01 Running with dbt=1.7.7
22:44:02 Registered adapter: duckdb=1.7.1
22:44:02 Unable to do partial parsing because saved manifest not found. Starting full parse.
22:44:03 Found 1 model, 2 sources, 0 exposures, 0 metrics, 391 macros, 0 groups, 0 semantic models
22:44:03
22:44:07
22:44:07 Finished running in 0 hours 0 minutes and 4.87 seconds (4.87s).
22:44:07 Encountered an error:
Runtime Error
IO Error: Extension "${env:HOMEPATH}\.duckdb\extensions\v0.9.2\windows_amd64\duckdb.duckdb_extension" not found.
Candidate extensions: "md"
profiles.yml
analytics:
target: dev
outputs:
dev:
type: duckdb
path: '/path/to/folder/with/data/dbs/analytics.duckdb'
attach:
- path: '/path/to/folder/with/datadbs/source.duckdb'
type: duckdb
jwills commented
Pretty sure md
refers to the motherduck extension which ships by default; I'm really confused by this one. Does it go away if you exclude the attach
configuration block from your profile? Or if you keep the attach
block but remove the type: duckdb
option?
jagrafft commented
@jwills Removing the type
key from the attach
object seems to work. Thank you!!
Are you able to elaborate on why this might work?
Updated profiles.yml
analytics:
target: dev
outputs:
dev:
type: duckdb
path: '/path/to/folder/with/data/dbs/analytics.duckdb'
attach:
- path: '/path/to/folder/with/datadbs/source.duckdb'