I would like to access delta tables through ArcPy for a QC script that I am improving. Read-only. How could I output a Python dictionary that contains all the rows that were added/deleted/modified between a named version and DEFAULT for a particular feature class?

We are currently on an Oracle client, but we will be switching to SQL Server, if there are substantial differences between the two.

  • To paraphrase Sigourney Weaver, "There is no ArcSDE, only Enterprise geodatabase." The mechanism for locating differences between versions with Desktop is the Version Changes utility. Based on this GeoNet thread, it seems to be UI-only, not scriptable. – Vince Nov 14 '19 at 19:12
  • @Vince is correct that there is no arcpy tool that will allow you to do this directly. You can, however, resolve this information using SQL queries. In practice, you could call your SQL statements via Python and then build the dictionary. Can you clarify what you have already tried and the specific issue(s) you've run into? – Radar Nov 14 '19 at 19:17
  • @Radar I haven't tried anything yet because I don't have a lot of experience working outside of the arcpy library. I have found this help doc from ESRI, and I planned on applying these concepts inside python, probably through ArcSDESQLExecute. – jesnes Nov 15 '19 at 16:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.