I have a geodatabase with a feature layer of parcels and a scalar database of consumption data for those parcels. Using SQL Server 2012r2 and ArcGIS 10.5.
In ArcCatalog, I open the parcel database connection and create a view which queries the consumption data. The view creation completes without error, but ArcCatalog does not show the view (as a "table") in the connection. Refreshing the connection, disconnecting and reconnecting the DB connection doesn't help.
Yet, if I try to create the view again, I get error "table already exists", and if I open the geodatabase from SQL Server manager, I can see the view and even run it and see expected data.
Why won't ArcCatalog show the view?
I suspect it doesn't enumerate DB schema from the geodatabase that it doesn't have SQL level access to, but connection to the geodatabase has full owner privileges (using SQL rather than Windows authentication).
Once the view is visible in the geodatabase, I plan to use it to define a relationship class with which I hope to be able to visualize consumption by (groups of) parcels, showing numbers and bars on a map, or color-coding parcels by consumption.