idea Ship duckdb-engine with ArcGIS Pro in ArcGIS Pro Ideas

Ship duckdb-engine with ArcGIS Pro

TylerT — Tue, 15 Jul 2025 15:29:11 GMT

Hello,

ArcGIS Pro currently ships with:
-pyhthon-duckdb
-sqlalchemy

Both of which are great Python Libraries for cutting edge spatial analysis, but to get them to talk, please additionally provide:
-duckdb-engine

Without the duckdb-engine installed, creating an sqlalchemy engine for duckdb will error.

import duckdb from sqlalchemy import create_engine engine = create_engine("duckdb:///:memory:")

Running the above code results in (without duckdb-engine installed):
NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:duckdb

Thanks for listening.

Tyler
ArcGIS Pro 3.5

Re: Ship duckdb-engine with ArcGIS Pro

HannesZiegler — Tue, 07 Oct 2025 20:01:19 GMT

Hi @TylerT and others, we have packaged duckdb-engine on the esri channel, duckdb-egine is now available to install into a clone in ArcGIS Pro versions >=3.5.

You can use the ArcGIS Pro Package Manager available on the backstage (Project tab) to accomplish this. First navigate to the Package Manager, then click the cog icon at the top-right of the Package Manager to open the Environment Manager and click the Clone arcgispro-py3 button to clone the default environment. Once done, double-click the cloned environment in the list to activate it. Now exit the Environment Manager and click the Add Packages on the Package Manager, then search duckdb-engine and install.

Re: Ship duckdb-engine with ArcGIS Pro

TylerT — Tue, 28 Oct 2025 12:11:28 GMT

@HannesZiegler; Excellent. Thank you!

Re: Ship duckdb-engine with ArcGIS Pro - Status changed to: Implemented

HannesZiegler — Wed, 29 Oct 2025 14:41:08 GMT

We have packaged duckdb-engine on the esri channel, duckdb-egine is now available to install into a clone in ArcGIS Pro versions >=3.5.

You can use the ArcGIS Pro Package Manager available on the backstage (Project tab) to accomplish this. First navigate to the Package Manager, then click the cog icon at the top-right of the Package Manager to open the Environment Manager and click the Clone arcgispro-py3 button to clone the default environment. Once done, double-click the cloned environment in the list to activate it. Now exit the Environment Manager and click the Add Packages on the Package Manager, then search duckdb-engine and install.