If you're just refreshing the table, you might consider using the ArcGIS Python API.
How you use it depends a lot on the source of the data, but since it's non-spatial, you've got a lot of options. Can you elaborate on where the data's coming from?
If it's relevant to your process, we use pandas to update hosted tables in much the same way. Here's one example:
import pandas as pd
from arcgis import GIS
gis = GIS('your-org-url', 'user', 'password')
hosted_table = gis.content.get('hosted-service-itemID').tables[0]
db_constr = 'mssql+psycopg2://user:pass@hostname/db'
query = 'SELECT * FROM Database.dbo.SomeTable'
df = pd.read_sql_query(query, db_constr)
# Do some data manipulation as needed here
hosted_table.manager.truncate()
i = 0
# Append new records in chunks
while i < len(df):
fs = df.iloc[i:i+100].spatial.to_featureset()
adds = hosted_table.edit_features(adds=fs)
i += 100
Also: if you don't want to do a full truncate, it's possible to use the same python modules to identify rows to update in place rather than delete and re-add. But that gets a bit more complex. Let me know if you'd like elaboration on that.
Then just get your python script scheduled to run daily on a machine that has access to the source data.
Final note: supposing your source data isn't a true database, there are numerous other ways of getting tabular data into a dataframe.
- Josh Carlson
Kendall County GIS
