Ship duckdb-engine with ArcGIS Pro

TylerT

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

 

HannesZiegler

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.