Is there a way to pull information from non spatial database query as Query Layer in arcGis pro and publish it as service without adding view or table in spatial database ?
There's currently no way to have a service with zero feature layers. If you can add your query layer to an existing service that's ideal. If not, you can use your database's geometry functions to add an extra column to make it spatial. An example for SQL Server:
SELECT a.*, geometry::STGeomFromText('POINT (0 0)', 3857) [Shape] FROM [user].[table] a
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
