Insights for ArcGIS can't read shape field in views, in native SQL table?

Question

Dear Insights for ArcGIS community. We are facing with an interesting problem. We have in the same SQL instance two different database, one of them enterprise and one of them is native SQL database. We have to store our views in the native SQL database, but some of the views are using tables from the enterprise geodatabase, with the shape field.

Insights for ArcGIS (version 3.4) can't load these views into a workbook. Just for testing if I remove the shape field, it is just works fine in the application. There is no permission related issues, with the two different database, the dedicated user, has all the rights to access the databases.

Has anyone ever encountered this problem? Or it is just a bug? Or a limitation of the application?

LaszloCsunderlik1 · Accepted Answer

I have found the solution for the problem. The created view has to be have an unique field (OBJECTID). In my case I had unique fields but during the inner joins, (which I used for the creation of views) there were some repetitions in the unique fields.

So the solution is that during the creation of the view you have to use the ROW NUMBER() to create OBJECTID field from some unique fields. After that if you add this view to an Insights page you have to select an uniqueid field (in my case it is the OBJECTID) and after the application can handle the shape field too and it shows that we have a location field.