Share/Overwrite Table Truncating at 850000 Records

Question

We push data from our SQL database to AGOL using the Share Table and Overwrite Table function in ArcGIS Pro. When we do this, the published table in AGOL is truncated to only the first 850,000 rows. Does anyone know if there is a cap on that feature? If we publish as a web layer, all rows are uploaded, but since it is a table, ArcGIS Pro won't allow us to use the replace function.

SeanReynolds · Answer

I think this could work for us. We'll need to figure out how to specific that times are EST and not UTC, but I'll give the method a try and see if it works for us.

SeanReynolds · Answer

We'll definitely try the append option. This is the first big upload we're performing. The data works really well in our AGOL dashboards and maps, the problem is getting it up there.

jskinner · Answer

@SeanReynolds,

I would try a truncate/append method instead.  See the following document.