Creating Query table from sql view

AdCulver — Mon, 20 Sep 2021 16:22:37 GMT

I am trying to create a query table from a sql view; there is no geometry associated with the table. I need to join the table to two separate feature classes. When I try to run the "Make Query Table" tool I get the following error: 000055: Cannot create a Query Table for this workspace: Description Creating a query table is not supported for the specified workspace. Query tables can only be created using data from a geodatabase or an OLE DB connection. Solution Convert the data to one of the workspace types that support the creation of query tables. I am directly connecting to the sql database through my project. I do not want to convert the view into a static table so the data is "live" and attributes will update without having to refresh or run a script. Any ideas are greatly appreciated.

Re: Creating Query table from sql view

MichaelVolz — Mon, 06 Dec 2021 15:26:59 GMT

Are you trying to perform this process in a script? Is the data in a format to be spatially enabled by either geocoding the data or creating an xy event layer?

topic Re: Creating Query table from sql view in ArcGIS Pro Questions

Creating Query table from sql view

Re: Creating Query table from sql view