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 as a filter in the Filters pane of Data Marketplace itself, you need to update the Filters settings.

Tip 
  • You cannot create more than 20 relation indexes in Data Marketplace
  • 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.
  • You cannot add more than four relations to one relation path.
  • You can include 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.
  • You can't use relation types with special characters in the relation type name.
  • Complex relations are not supported as custom relation paths.
  • We recommend that you don't create relation indexes with identical relation paths. If they both show up as filters in the Filters pane, it will be confusing to your users. Currently, we don't prevent you from creating identical relation indexes.
  • Also, check Relation-based search limitations and Data Marketplace limitations and guidelines.
Important 

In Collibra 2024.02, we've launched a new user interface (UI) in beta for Collibra Data Intelligence Platform! You can learn more about this latest UI in the UI overview.

Use the following options to see the documentation in the latest UI or in the previous, classic UI:

Requirements and permissions

  • Make sure you have identified the relation-paths that you want to use. For information on how to construct relation paths, go to About relation indexes.
  • Make sure the Relation-based search setting has been enabled. Newly created relation indexes are used in the search only if the relation-based search feature is enabled.
  • You are an administrator in Data Marketplace.

Steps

  1. On the main toolbar, click Products icon, and then click Cogwheel icon Settings.
    The Collibra 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. In the Data Marketplace section, click Filters.
  4. Click Manage Relation-Based Filters.
    The Manage Relation Indexes page opens. It provides an overview of all relation indexes in the environment.


  5. Click Create an Index.
    The Create an Index page opens.
  6. Enter the name of the filter.
    • Provide a clear and meaningful name. This name will be the default name in the Filters pane in Data Marketplace. For information on defining filter names, see Configuring the filters.
    • 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 filters 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.
  7. Specify the relation path.
    1. Click and select the first asset type in your relation path.
    2. From the drop-down list, select the first asset type in your relation path.
    3. 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.
      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.

    4. 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.

  8. If required, click to add another relation path.
  9. 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.
  10. If required, make the relation index visible as a filter in the Filters pane of Data Marketplace via the Filters settings.

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