topic Re: Is it possible to join a non-spatial query layer from a data lake (on premise) to an egdb featureclass? in ArcGIS Pro Questions

Is it possible to join a non-spatial query layer from a data lake (on premise) to an egdb featureclass?

JuneAcosta — Wed, 05 Oct 2022 18:49:23 GMT

Using ArcPro 2.9.3, I created a non-spatial query layer from our data lake, and now I want to join the query layer to a polygon featureclass from our egdb, but keep getting an error that the featureclass is a locked table.

Is it possible to join a non-spatial query layer to a featureclass? I'm also curious how others are integrating non spatial data from enterprise systems (EAM, Permits, Financial) to GIS.

Re: Is it possible to join a non-spatial query layer from a data lake (on premise) to an egdb featureclass?

jcarlson — Wed, 05 Oct 2022 19:02:09 GMT

We've got a handful of non-spatial databases and the like that we need to pull from to populate our parcel attributes. We use Python (particularly, the pandas module) to query from those other DBs, join based on a common key field, then push updates to the destination layer.

Re: Is it possible to join a non-spatial query layer from a data lake (on premise) to an egdb featureclass?

MichaelVolz — Thu, 06 Oct 2022 02:12:22 GMT

Are you looking to use this data in a service, as from my experience and I believe per ESRI documentation, the join would need to be in the same database? As such you would need to save the data into the enterprise geodatabase and then remove the join to the query layer. This can be scripted and automated if it needs to be done on a regular interval.