Model Export Table tool doesn't auto refresh fields list from SQL view

AndreaB_ — Mon, 16 Jun 2025 17:00:21 GMT

Hi all,

ArcGIS Pro 3.3.5 and SQL 2022.

I have added a field in my SQL database view and I am using Export Table in my Model to export that table to my SQL geodatabase. The problem I just found is that my existing model doesn't export the new field from the database view. Validate didn't refresh it. Deleting and recreating the link didn't refresh the field list. I think I need to manually add the field to the Parameters of the Export Table tool. Or recreate the Export Table tool and variable again.

Is this 'normal' behavior? I was thinking since the model is pointed to a sde connection it would just read the new table with the new field. Anyway it can auto refresh? I can see us adding more fields in the SQL view in the future.

I found a somewhat similar post: https://community.esri.com/t5/modelbuilder-questions/submodel-update-refresh-after-modification/td-p/1312362

Thanks!

topic Model Export Table tool doesn't auto refresh fields list from SQL view in ModelBuilder Questions

Model Export Table tool doesn't auto refresh fields list from SQL view