Relationship filters in Catalog allow you to query assets based on how they relate to other assets. You can filter by specific related assets, check for the existence of relationships, or exclude assets with certain relationships. Relationship filters are available after you have filtered a specific asset type.
- Asset type selection: You must first apply a filter to drill down to a specific asset type. This lets the filter show you contextually relevant relationship types.
- Relationship filtering: Once you select an asset type, the system queries the definitions collection to retrieve all relationship types where the subject or object matches the current asset type ID. You can then select a relationship type and apply filtering options.
To filter catalog assets by relationships:
You have successfully filtered catalog assets by their relationships. The filtered results help you discover related assets, understand data lineage, and identify asset dependencies.
Example 1: Finding table columns that map to business terms
To find all Table Columns that map to a specific Business Term:
- Apply a filter to select Table Columns as your asset type.
- On the relationship filter page, select the maps to Business Term relationship type.
- Choose filter Select related asset.
- Select the Business Term you want to find mappings for.
- Choose Match Any to return all Table Columns mapped to that Business Term.
- Select Apply.
The results display all Table Columns that have a "maps to Business Term" relationship to the selected Business Term.
Example 2: Combining multiple relationship filters
You can combine relationship filters with other asset filters to create complex search queries. All filters use AND logic, meaning an asset must match all filter criteria to appear in the results.
To find Table Columns that both map to a Business Term AND are harvested by a specific Connection:
- Apply a filter to select Table Columns as your asset type.
- Apply the first relationship filter: Select maps to Business Term and choose a specific Business Term.
- Select Add Relationship Filter.
- Apply the second relationship filter: Select is harvested by Connection and choose a specific Connection.
- Select Apply.
The results display only Table Columns that satisfy both relationship criteria, allowing you to find assets with complex relationship requirements.