Select to view content in your preferred language

Requirement for ArcGIS to read tables saved in PostgreSQL

402
1
09-05-2023 07:34 PM
JingukKim1
New Contributor

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?

0 Kudos
1 Reply
ChrisUnderwood
Esri Contributor

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-geodatabas...

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

 

0 Kudos