Interop workbench returns 'No module named psycopg2'

Question

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?

bharold · Answer

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.