Create layer views from non-hosted feature layers in the ArcGIS Enterprise portal

Summary

Feature layer views control access to a feature layer by applying filters, field visibility rules, and sharing permissions, allowing specific user groups to interact with relevant data without modifying the source layer. These settings enhance data security and improve performance by restricting access to sensitive information and reducing data volume.

However, feature layer views are only supported for hosted feature layers and hosted spatiotemporal feature layers. Since these layers are stored in ArcGIS Data Store, users can create and manage views directly in the ArcGIS Enterprise portal.

This article outlines the workflows to create layer views from non-hosted feature layers in the ArcGIS Enterprise portal. In this example, the layer view must include only the data from a referenced feature layer where the IsBeverage field is '0'.

Procedure

Create a query layer in ArcGIS Pro and publish as a referenced feature layer

Create a query layer by executing an SQL query on the source feature layer, and publish it as a referenced feature layer. The query layer remains linked to the source data and is automatically updated to reflect changes in attributes or geometry.

1. Open the ArcGIS Pro project with the configured database connection.
2. Create a query layer from the feature layer stored in the database. Refer to ArcGIS Pro: Define a query on the New Query Layer dialog box for instructions.
3. Share the query layer as a referenced feature layer. Refer to ArcGIS Pro: Share a web feature layer using the default configuration for instructions.

Apply definition queries and publish as a map image layer or a feature layer

Use definition queries in the Layer Properties dialog box to filter data in the source feature layer before publishing it as a map image layer or a feature layer. Publishing a feature layer creates an editable feature layer that syncs with the source data and a non-editable map image layer.

1. Open the ArcGIS Pro project with the configured database connection.
2. Create and apply definition queries to the source feature layer. Refer to ArcGIS Pro: Create a definition query for a layer for instructions.
3. Share the layer as a map image layer or a feature layer. Refer to ArcGIS Pro: Share a map image layer using the default configuration for instructions.

Create a database view and publish as a map image layer or a non-editable feature layer

Note:
The Create Database View tool requires an ArcGIS Pro Standard or Advanced license.

Use the Create Database View tool to create a database view from the source feature layer and publish it as a map image layer or a read-only feature layer. The view layer is dynamically updated to reflect changes in the source data, but does not allow editing.

1. Open the ArcGIS Pro project with the configured database connection.
2. In the Catalog pane, right-click the database connection and select New > View.
3. In the Create Database View pane, for Input Workspace, select the database containing the feature layer.
4. For Output View Name, specify a name for the database view.
5. For View Definition, enter an SQL statement to define the view.
6. Click Run.

7. Share the view layer as a map image layer or a feature layer. Refer to ArcGIS Pro: Share a map image layer using the default configuration for instructions. To share a feature layer, perform the additional workflows below before publishing.
   1. In the Share As Web Layer pane, on the General tab, check the Feature check box.
   2. On the Configuration tab, under Layer(s), for Feature, click Configure Web Layer Properties .
   3. For Feature Properties, expand Operations and uncheck the Enable editing and allow editors to: check box.

The layer view filters the IsBeverage field to include only records with a value of '0', as shown in the image below.