Table joins while using branched versioning

05-11-2022 01:07 PM
New Contributor II

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. 

0 Kudos
3 Replies
Esri Frequent Contributor

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.

--- George T.
0 Kudos
MVP Esteemed Contributor

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.

- Josh Carlson
Kendall County GIS
0 Kudos
New Contributor III

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.

0 Kudos