[gdal-dev] ADBC driver and DuckDB on Windows

[Michael Smith]

Seth,

Have you tried adding https://anaconda.org/conda-forge/libadbc-driver-manager to your conda build and then adding duckdb.dll?

Mike


-- 

Michael Smith 
RSGIS Center – ERDC CRREL NH 
US Army Corps 





On 7/12/25, 6:51 AM, "gdal-dev on behalf of Seth G via gdal-dev" <gdal-dev-bounces at lists.osgeo.org <mailto:gdal-dev-bounces at lists.osgeo.org> on behalf of gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>> wrote:


Hi all,


I'm wondering if anyone has got this working on Windows?


With a test.db the following works fine on a full Linux GDAL Docker image:


docker run -it --name gdal-ubuntu -v D:/Data/GDAL:/data ghcr.io/osgeo/gdal:ubuntu-full-3.11.0 /bin/bash
ogr2ogr out.gpkg test.db


>From the docs https://gdal.org/en/latest/drivers/vector/adbc.html <https://gdal.org/en/latest/drivers/vector/adbc.html>


"Assuming libduckdb.so, libduckdb.dylib or duckdb.dll is available (and it is in a system location, or can be located through LD_LIBRARY_PATH on Linux, DYLD_LIBRARY_PATH on MacOSX or PATH on Windows)."


I'm trying to get this working using GDAL via Conda on Windows. The ADBC driver is isntalled:


gdal vector --formats
# includes ADBC -vector- (ro): Arrow Database Connectivity


I tried downloaded the duckdb.dll from https://duckdb.org/docs/installation/?version=stable&environment=cplusplus&platform=win&download_method=direct&architecture=x86_64 <https://duckdb.org/docs/installation/?version=stable&environment=cplusplus&platform=win&download_method=direct&architecture=x86_64> (https://github.com/duckdb/duckdb/releases/download/v1.3.2/libduckdb-windows-amd64.zip <https://github.com/duckdb/duckdb/releases/download/v1.3.2/libduckdb-windows-amd64.zip>) and setting the path:


$env:Path = "D:\Tools\libduckdb-windows-amd64;" + $env:Path
ogr2ogr out.gpkg test.db


Each time, the following error is returned:


ERROR 1: Unable to open datasource `test.db' with the following drivers.


With a longer command:


ogr2ogr -f parquet overture-vt-addresses.parquet `
-oo ADBC_DRIVER="D:/Tools/libduckdb-windows-amd64/duckdb.dll" `
-oo PRELUDE_STATEMENTS="LOAD SPATIAL" `
-oo PRELUDE_STATEMENTS="LOAD PARQUET" `
-oo PRELUDE_STATEMENTS="load httpfs" `
-oo PRELUDE_STATEMENTS="load aws" `
-oo SQL="select * from read_parquet('s3://overturemaps-us-west-2/release/2025-05-21.0/theme=addresses/type=address/*')'" ADBC:


Results in:


ERROR 1: AdbcLoadDriver() failed:
ERROR 1: Unable to open datasource `ADBC:' with the following drivers.


I tried various paths for ADBC_DRIVER:


-oo ADBC_DRIVER="D:/Tools/libduckdb-windows-amd64"
-oo ADBC_DRIVER="D:/Tools/libduckdb-windows-amd64/duckdb.dll"
-oo ADBC_DRIVER="D:\Tools\libduckdb-windows-amd64\duckdb.dll"


Just to note the following works in the Conda environment:


python -c "import ctypes;ctypes.CDLL(r'D:\Tools\libduckdb-windows-amd64\duckdb.dll')"


conda install duckdb doesn't help and `conda install conda-forge::libduckdb` isn't available on Windows. 


Thanks for any suggestions,


Seth


_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/gdal-dev <https://lists.osgeo.org/mailman/listinfo/gdal-dev>