I have an OLE DB connection in ArcGIS Pro (it's pointed at a Starburst instance - https://docs.starburst.io/clients/odbc.html). I am able to expand the OLE DB database (.odc) in my contents and look at the tables in my catalog. However, this only works for looking at individual tables.
I've tried to add a QueryLayer, hoping I could create a new layer using SQL joining a couple tables together, but my .odc connection doesn't show up in the QueryLayer workspaces area. My only option is creating a new database connection to an RDMS instance - no option to create a new OLE DB connection.
Is this expected behavior? How can I execute SQL against an OLE DB connection in ArcGIS Pro to create custom views of the tables in my source
