None of the Statistics Plugins Work. Same Error for All Tools.

[ack_ack_ack_ack]

Per the title, none of the statistics features work with my data set in ArcGIS Pro 3.4.3

field = self.allFields[fieldName.upper()]

~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^

KeyError: 'BIKE_SHARE.PUBLIC.%BIKE_STATIONS_DATA_3_8_52_305_471.START_POPULARITY'

The data source is a Postgresql table. Database name bike_stations_data. Schema name is public. Database name is bike_share.

It looks like ArcGIS has some sort of cached version of the data in some kind of internal table BIKE_STATIONS_DATA_3_8_52_305_471.

The column of interest is start_popularity. It's an integer.

Same error for Ordinary Least Squares, Generalized Linear Regression, Local Bivariate Relationships.

The tools work like magic in ESRI's youtube videos. Not sure what I am doing wrong.

Is it the case that while one can connect to external databases, nothing actually works with an external database?

[ack_ack_ack_ack · Accepted solution]

AFAICT, using a PostgreSQL database is mostly broken.  Documentation suggests this should "just work."  And, it does nothing of the kind.
PostgreSQL is free software and they didn't bother testing *anything* beyond connecting to the database.  What a hot mess.
https://pro.arcgis.com/en/pro-app/3.3/help/data/databases/database-connections-in-arcgis-pro.htm

What does work is a query as a data source.  Which, somehow, is different than just a connection to a database.

More questions than answers about the ESRI's software development process after this. Yikes!

[ack_ack_ack_ack]

Null. Duplicate

[ack_ack_ack_ack]

Null.  Triplicate