Select to view content in your preferred language

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

36
0
yesterday
Labels (3)
AndreaB_
Frequent Contributor

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.

AndreaB__0-1750092948548.png

 

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... 

Thanks!

0 Kudos
0 Replies