QueryLayer for OLE DB connection (Starburst)

Jay_Gregory — Mon, 23 Oct 2023 18:58:55 GMT

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

Re: QueryLayer for OLE DB connection (Starburst)

Robert_LeClair — Mon, 23 Oct 2023 20:03:59 GMT

OLE DB connections in ArcGIS Pro are read-only and generally are limited in usage. This list here shows what is allowed using OLE DB connections. Does not appear creating new query layers via SQL is supported.

topic Re: QueryLayer for OLE DB connection (Starburst) in ArcGIS Pro Questions

QueryLayer for OLE DB connection (Starburst)

Re: QueryLayer for OLE DB connection (Starburst)