Non Spatial Database tables in ArcGIS Pro

[vijaybadugu]

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 ?

[DavidSolari]

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