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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.