Interop workbench returns 'No module named psycopg2'

TomGeo — Tue, 08 Apr 2025 09:49:09 GMT

I am using sqlalchemy in a Python script that I created in VSC using a clone of the arcgispro-py3 environment.

When I run the code in VSC there is no problem. Now I need to have the code running in the Data Interop Workbench in a PythonCaller, and that's where I am facing

Python Exception <ModuleNotFoundError>: No module named 'psycopg2'

I went to check the Package Manager in ArcGIS Pro to check if the clone is set as the active environment and if I in fact have psycopg2 installed. Here a screenshot of the installed module

and here the sqlalchemy

Can I get some help why I am facing this issue, if the module is installed?

Re: Interop workbench returns 'No module named psycopg2'

BruceHarold — Tue, 08 Apr 2025 13:04:00 GMT

Tom in the Workbench application, open the Tools menu and in the Translation options set the Python compatibility to agree with Pro - the option named "Esri ArcGIS 3.11" or similar, depending on version.

topic Re: Interop workbench returns 'No module named psycopg2' in ArcGIS Data Interoperability Ques.

Interop workbench returns 'No module named psycopg2'

Re: Interop workbench returns 'No module named psycopg2'