idea Create Database View — SQL Expression Builder in ArcGIS Pro Ideas

Create Database View — SQL Expression Builder

Bud — Thu, 04 Jan 2024 08:04:15 GMT

It would be helpful if we could use the SQL Expression Builder in the Create Database View geoprocessing tool.

Source: @AlfredBaldenweck 's comment in Improve SQL Expression Builder
The weird thing is that the implementation of various [SQL Expression] features we want is all over the place. We have them in some workflows but not others.
...Creating a view? Good luck. You gotta know your datasets very well before you can successfully write the query.

Re: Create Database View — SQL Expression Builder

AlfredBaldenweck — Tue, 03 Oct 2023 17:40:37 GMT

Hard agree, whoever originally said that is a genius (hahahaha).

Having some sort of expression builder, as well as a validator, would be awesome.

The current method of "write your query and then see if fails halfway through" is... suboptimal.

Re: Create Database View — SQL Expression Builder

KariBuckvold — Thu, 09 Jan 2025 20:19:03 GMT

agree! building a definition query will give you clues as to errors in your script but absolutely none for this tool.