Requirement for ArcGIS to read tables saved in PostgreSQL

JingukKim1

Hi,

I am using another GIS software (Alteryx) to create a spatial table in PostgreSQL database connected to ArcGIS Enterprise.

When I try to open that table in Alteryx, everything is fine. I can see the columns, values and shapes.

However, when I try to open it in ArcGIS Pro, it says "Attribute column not found", and does not open.

What should I do differently for ArcGIS to be able to ready this table correctly?

ChrisUnderwood

Hello @JingukKim1  , please could you post a description of your PostgreSQL Table so that we can see it's Column Names and Data Types. It could be that it is using an Esri Reserved Word, or perhaps exceeding an Esri limit ?

https://community.esri.com/t5/esri-technical-support-blog/words-by-reservation-only/ba-p/898664

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-saphana/enterprise-geodatabase-limits.htm

https://support.esri.com/en-us/knowledge-base/faq-what-characters-should-not-be-used-in-arcgis-for-fi-000005588