Hi Everyone.
I am trying to create a query layer in ArcGIS Pro by connecting to a Microsoft SQL Server Non Spatial database. The SQL query contains Joins and Where clause (not sure if this may influence something).
The retrieved data contains Lat and Long attributes and I want to display these locations on the map. However, after validating the SQL query, the Spatial Property is not active to me. This way, when the data is added, it is added as tabular data only.
I could use the 'Display XY Data' option (see below). However, this would generate a layer in my local machine that would not update whenever the data changes in the database.
Is there a way to activate the Spatial Property option when creating the Query Layer to automatically display locations based on the Lat/Long attributes of my source data query in ArcGIS Pro? That would guarantee that any data is displayed or will disappear from the map whenever the job status change in the database system.
Thanks 🙂