Connecting to PostgreSQL database hosted on Amazon from ArcPro

430
3
02-16-2023 12:45 PM
SCVTAGIS
New Contributor II

I'm trying to connect to a PostgreSQL database that is hosted on Amazon Web Services using ArcPro. The problem I'm seeing is that after the connection, it only displays the "tiger" files and not the rest of the files or schemas (as shown in the screenshot attached below).

 

YDi3m.png

When I make the same connection in QGIS, I'm seeing all the schemas and the correct files that I intend to work with (screenshot below). What am I doing wrong here?

2cHHu.png

0 Kudos
3 Replies
George_Thompson
Esri Frequent Contributor

What user are you connecting as?

Are you expecting to all the data in all the schemas?

--- George T.
0 Kudos
SCVTAGIS
New Contributor II

My user has been granted all administrative privileges.

I am expecting to have the ability to select the schema of my choice, such as the 'inventory' schema, as well as the content contained within it.

0 Kudos
George_Thompson
Esri Frequent Contributor

I do not think that ArcGIS Pro is designed to allow you to pick a schema like that. You would need to grant access to the user and that specific schema. If my memory serves me correctly, we look at the public / sde schema (if it is there) by default.

Is this going to be an Enterprise Geodatabase?

Here is a list of permissions needed for Geodatabases in PostgreSQL and our client: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/privileges-postgre... (in case you have not seen this). There is also a reference to the cloud permissions needed.

--- George T.
0 Kudos