ArcGIS Pro 3.2; file geodatabase:
When creating a database view in a file geodatabase, the view doesn't get automatically registered with the geodatabase. The user needs to do it manually using the Register with Geodatabase geoprocessing tool.
That seems like an unnecessary manual step that people often overlook.
As Esri Support said:
Case 03490768 - Database view on feature with nil geometry hangs when added to map
"Registering views with geodatabase also helps in resolving many issues related to views."
Can that behaviour be changed so that FGDB views get automatically registered when the view is created?
I understand why mobile and enterprise geodatabase views do not get automatically registered with the geodatabase:
Thanks for the Idea @Bud
Can you walk me through the workflow in fgdb where you're hitting an issue and are required to register a file geodatabase view with the GP tool? I'd like to reproduce it so we can understand.
What issue are you hitting, and does registering the view solve the issue for you?
@SSWoodward Good question. I don't recall a specific scenario where registering a view with the FGDB was necessary/solved an issue. I've just been doing it because Esri Canada Support generally recommends registering views:
Case 03490768 - Database view on feature with nil geometry hangs when added to map
"Registering views with geodatabase also helps in resolving many issues related to views."
I've found that registering enterprise geodatabases view solves a lot of issues. I figured the same might apply to file geodatabases.
It would help if Esri could clarify in the docs what GDBs they recommend registering views in. And why registering views fixes issues in some GDBs, such as enterprise GDBs.
As for file GDBs, I wonder if there might be ArcGIS functionality that requires views to be registered. Maybe it's possible to publish a registered FGDB view to a map service? https://community.esri.com/t5/arcgis-enterprise-questions/views-are-not-supported-in-arcgis-server-f...
If the Register with Geodatabase GP tool is not intended to be used on FGDB views, then that tool should be changed so that FGDBs are not valid inputs.
When to register a view depends on how you and your workflows intend to use the data, so specific recommendations on how you should manage your views would be difficult to provide. In general, if you want to be able to interact with the view as a geodatabase object in an enterprise geodatabase, registration is required.
The general guidelines for views are in the doc, which can be found here.
If you encounter any bugs related to using fgdb views that are addressed with registration, please give us an update.
For the GP tool idea, we don't have a pattern of GP tools performing differently in different workspaces. For consistency, creating a view using the GP tool or create view wizard will create an unregistered view in all workspaces.
@SSWoodward It sounds registering a FGDB view with the GDB makes it so the view can be published in a map service:
Can a FGDB database view that is registered with the geodatabase be published as a map service?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.