topic Re: ArcGIS Pro spatial view column not found after adding it in SQL Server in ArcGIS Pro Questions

ArcGIS Pro spatial view column not found after adding it in SQL Server

PLadd — Thu, 02 Feb 2023 20:43:13 GMT

I have a spatial view created in SQL Server. Works fine in ArcGIS Pro. HOWEVER, if I add a new field to the table "joined" in the spatial view in SQL Server, that new field does not appear in ArcGIS Pro where the spatial view is in use. If I re-add the spatial view, it shows the new field. But I can't do this because I have dozens of expressions and HTML in the popup and I'll lose a lot of work. I tried closing and re-opening - nothing. I tried refreshing the data in the "List by data Source" in the TOC and Refreshing the geodatabase connection.

Anybody have any tricks to get the new field to display in an existing spatial view layer in ArcGIS Pro?

Re: ArcGIS Pro spatial view column not found after adding it in SQL Server

Robert_LeClair — Thu, 02 Feb 2023 21:36:37 GMT

If you go into the Layer Properties for the existing database view, you should be able to go into the properties to update the view definition to include the new field.

Re: ArcGIS Pro spatial view column not found after adding it in SQL Server

PLadd — Fri, 03 Feb 2023 16:41:49 GMT

Thanks @Robert_LeClair for the response and the help (and for the link). I guess I was expecting that if I changed the spatial query in SQL Server and then refreshed/reopened in ArcGIS Pro, the new spatial query would get pulled through. It seems it doesn't work that way.

Just to expand on your instructions, I went to the layer properties, clicked on Source, then clicked on the edit icon for Query (see image below). In the Query window I can double click on the fields to be added (then add commas of course). I guess I could also copy/paste the query from SQL Server. Thanks again for helping me out.

Re: ArcGIS Pro spatial view column not found after adding it in SQL Server

Robert_LeClair — Fri, 03 Feb 2023 17:09:14 GMT

Certainly! Happy to assist. You are correct that updating the SQL in SQL Server Management Studio does not update the Database View in ArcGIS Pro. The DB view is stored in the eGDB. The workflow you described in your response is correct as well. I'm glad it worked out! Have a great weekend!