Truncate and Append

Question

I am trying to update a layer in AGOL by truncating it in a python notebook and then appending the updated data using python's append function. I was able to truncate the AGOL layer in my python notebook, but the append takes too long or it just gets stuck. Note: There are about 200k records that need appended. Is there a better workflow for this task. I need it to be automated hence the python script

vijaybadugu · Answer

You are using service in agol, you could use sql query along with arcpy cursors to update/delete /insert. Append also uses upsert functionality. If you are using backend database like sqlserver, Postgre , you could use sql queries to update using some primary key field. Geometry field stored in the backend database as binary, you can’t compare that with another feature class using sql .

ChaceCarpenter · Answer

Can I compare the geometry of the feature class in agol to the newer feature class and only update the features whos geometry has changed with this method?  I feel like comparing the 2 tables will require more computing power than just truncating and appending. Is this not true?

ChaceCarpenter · Answer

Are you using the sql within a arcpy function?