topic Re: Table joins while using branched versioning in ArcGIS Enterprise Questions

Table joins while using branched versioning

RussellAuwae — Wed, 11 May 2022 20:07:49 GMT

Are table joins not allowed on branched versioned data? I keep getting a user permission error on both the version I created and the DEFAULT, and I'm the data owner. I think my best option at this point is to download the layer, perform the join, and then publish and version it again. Versioning seems like it has it's limitations, and really just for basic editing work.

Re: Table joins while using branched versioning

George_Thompson — Wed, 11 May 2022 21:01:46 GMT

Once you branch version data (and publish as a service) you cannot connect directly to the feature classes in the Enterprise Geodatabase. So I do not think the join would work there, you may be able to join to the feature service.

Re: Table joins while using branched versioning

jcarlson — Wed, 11 May 2022 23:52:43 GMT

What is it you're trying to do, exactly? If you write your SQL carefully, it's possible to use a Query Layer against branch versioned data.

Re: Table joins while using branched versioning

KevinWyckoff1 — Thu, 08 Feb 2024 16:51:55 GMT

I am curious if anyone ever found a solution to this? I have a feature service purpose built for editing branch versioned data, and when I just attempted to join I got this same insufficient permissions error.