Create a relation index

If the out-of-the-box relation-based filters and relation-based search don't match the organization's needs, you can create a new relation index.
Newly created relation indexes are automatically used in the relation-based search if this feature is enabled.
To use a relation index in Data Marketplace, you need to update the Filter facet settings.

Tip 

Prerequisites

Steps

  1. On the main toolbar, click Products iconCogwheel icon Settings.
    The Settings page opens.
  2. In the Search section, click Relation Indexes.
    The Manage Relation Indexes page opens. It provides an overview of all relation indexes in the environment.
  3. Click Create an Index.
    The Create an Index page opens.
  4. Enter the name of the index.
    • Provide a clear and meaningful name. This name will be the default name in Data Marketplace. For information on defining filter names, see Configuring the filter facets.
    • A space in the name will translate as an underscore in the relation index ID.
    Important 
    • Once the relation index is saved, you cannot change its name.
      However, you can change the display name in the Data Marketplace filter facet settings.
    • You can't use special characters in the relation index name. Only use alpha numeric characters and spaces.
      The maximum number of characters in the relation index name is 50.
  5. Specify the relation path.
    1. From the drop-down list, select the first asset type or asset type group in your relation path.
    2. For each relation you want to add, click and select the relation (relation type and target asset type) you need.
      The relation is added as an indent to the previous one.
      In the Preview, you get an overview of possible results for this index when it is applied as a filter to your data. The number of results in the preview is determined by Maximum batch size for relation path preview.
      Important 
      • You can't add more than four relations to one relation path.
      • You can't use relation types with special characters in the relation type name.

      Note The preview list doesn't always show all possible results. The list is based on a subset of the assets in Collibra. Sometimes, this can mean you don't see any results at all.

    3. If the end of your relation path is an attribute type, in the last relation click and select the attribute type you want to link to.
      You can select the following attribute types in a relation path: Text, Selection, Multiple Selection, Numbers, and Boolean (True/False). The attribute types Date and Script are not supported.

      Note If the attribute type included in the relation index has a cardinality higher than 1, we only show the first alphabetically sorted occurrence of the attribute as a filter option in the Data Marketplace Filters pane. This limitation applies to Selection, Multiple Selection, Numbers, and Text. For an example, go to Relation-based search limitations.

      The attribute type is added between brackets next to the asset type.

  6. If required, click to add another relation path.
  7. Click Create Index.
    The relation index is created.
    Data Marketplace starts indexing the relations. This can take some time.
    The new relation index is used in the relation-based search if this feature is enabled.
  8. If required, make the relation index visible as a filter/filter facet in Data Marketplace via the Filter facet settings.

For a full example, go to Example: Create a relation index.