Why can't I view postgresql materialized views in ArcGIS desktop?

[soniadickerson1]

I'm using postgres 9.3. and ArcGIS 10.3 desktop.  Views with the same granted privileges show up but materialized views do not. Anyone else run into this? Thanks greatly, Sonia

[ChristianWells]

Hi Sonia,

I can see this behavior in 10.3.1 as well, however, it looks like the behavior is fixed in 10.4. There are a lot of fixes made at this release (10.4) for querying the available objects and general performance.

Are you able to test or work with 10.4?

[soniadickerson1]

I don't have access to 10.4 right at this time, but I'm going to want to deploy an ArcGIS Server 10.3.1map service with these materialized views.  So even if I had 10.4 desktop, would it even work with ArcGIS Server 10.3.1?

[ChristianWells]

I haven't tested publishing to 10.3.1 Server, but I will look to test there.

[Anonymous User]

Not with PostGREsql but this is the same with Oracle I believe.  Are you trying to use query layers to access the Materialized View with  spatial data?  Without spatial data?  With Oracle, to oversimplify,  Materialized views don't support geometry.

[MichaelVolz]

Have materialized views been modified to support geometry in ArcMap 10.5.x and 10.6?

[soniadickerson1]

Postgres materialized views work in ArcMap 10.5.  Not sure about 10.6.  The geometry column needs to be named shape and you need a unique identifier column in order for all of the rows to show up.