This page has been machine-translated and may contain inaccuracies in phrasing or product terminology. If discrepancies exist, the original Japanese version takes precedence.

This document explains the feature for searching assets in the catalog. Searches are performed from the search bar in the workspace.

Intended Audience for this Feature

All Users

What is the Search Bar?

The search bar is the screen component displayed as "Search assets" located under the workspace logo. The search bar is always displayed at the top of the workspace, no matter which screen is open in the workspace.

Users can enter keywords in the search bar to search for assets registered in the catalog. The search results are displayed in the Asset List panel, but only assets that match all of the following will be shown:

Assets the user is permitted to access
Assets that match the Target Asset Selection
Assets that meet the Filter Conditions of the Asset List panel

Types of Searches You Can Perform

Fuzzy Search

This is the search mechanism that is realized when you enter only a keyword in the search bar.

Fuzzy Search calculates the closeness between the keyword and the target word and displays the results in order of closeness. Even if the word does not exactly match the keyword, words that loosely match, such as those with spelling variations or typos, may also be included.

Even if there are differences in uppercase and lowercase letters or minor spelling differences, if the system determines the word is close to the keyword, it will be displayed as a result that "roughly matches the keyword." However, many results, including unintended ones, may also be displayed.

Logical Search

Logical search is a search where you enter a search formula in the search bar using multiple keywords with logical operators or label-based syntax, and the information you want is displayed as a pinpoint result. When you enter a search formula in the syntax for logical search into the search bar, a search based on the formula is executed and results are output.

In principle, logical search performs phrase matching. Phrase matching is a search where the keyword is treated as a single phrase, and only those with matching word order and combinations are displayed as results. Some search formulas can also perform fuzzy searches.

How to Use the Search Bar

Search All Records

If you press the Enter key without entering a search keyword, all assets that match the Target Asset Selection and Filter Conditions will be displayed in the Asset List Panel.

A maximum of 100,000 assets can be displayed in the Asset List panel. Even if there are more assets in the catalog, assets exceeding 100,000 will not be displayed (this is due to the display limit of the Asset List panel).

Executing a Fuzzy Search by Entering a Keyword

If you enter a search keyword from the keyboard and press the Enter key, a fuzzy search will be performed on the metadata eligible for keyword matching among the assets that match the Target Asset Selection. The search results will be displayed in the Asset List panel in order of relevance to the keyword.

The following metadata will be targeted for keyword matching:

Logical Name
Physical Name
Description
Custom Property Value
DDL Comments

In a fuzzy search, even while entering keywords (that is, before pressing the Enter key), a dropdown list under the search bar will display results suggested from the keyword entered at that point. (This is so-called incremental search or live search.)

Note Please note that Filter Conditions are not applied to the suggested results. For example, even if you select only Physical Name as the target asset in the filter conditions, if there is an asset whose Description metadata matches the keyword during live search while entering the keyword, this asset will be displayed in the dropdown list as a suggested result. However, after entering the keyword in the search bar and pressing the Enter key, this asset will not be displayed in the Asset List panel. This is because Description is not selected in the filter conditions.

Target Asset Selection

Specify the assets to be searched by clicking the pull-down menu to the left of the search bar. (Multiple selections allowed)

Asset Type
For details, see Relationship Between Data Source Data Structure and Assets
Service Name
For details, see Relationship Between Data Source Data Structure and Assets
Custom Category
For details, see Custom Categories
Data Source Type
For details, see Data Sources
Data Quality
Specify the data quality. Quality standards are set by administrators or data stewards. For details, see How Asset Anomaly Detection Works

Setting Filter Conditions

Click the Filter button in the Asset List panel to display the Filter side drawer for setting conditions for assets to be displayed as search results. For details on filtering, see Browsing the Catalog

Executing a Logical Search by Entering a Search Formula

To perform a logical search, enter a search formula in the search bar. The cue for a logical search is a leading single quotation mark (').

If a single quotation mark is at the beginning, the following string will be recognized as a search formula input.
If there is no leading single quotation mark, the entire string entered will be recognized as a keyword input, and a logical search will not be performed.

Search Formula

For details on the syntax of search formulas, see Logical Search Syntax

Input Examples

The following search formula performs a phrase match search with the keyword "給与マスタ".

'"給与マスタ"

The following search formula performs a fuzzy search with the keyword "給与マスタ".

'給与マスタ

Note that in logical search, the search will not be performed until you press the Enter key in the search bar. In other words, results will not be suggested while entering the search formula. When you enter the search formula in the search bar and press the Enter key, the search results will be displayed in the Asset List panel.

Displaying Search History

When there is no input in the search bar, clicking [Search assets] will display a dropdown list of past search history.

A maximum of the 10 most recent searches will be displayed in the search history.
You can select a specific history from the dropdown list to re-execute that search.
When you hover the mouse over a specific history in the dropdown list, Delete will appear on the right side of the list. Clicking Delete will delete that history.
History is retained only while logged in. When you log out of the workspace, the history is deleted, and the next time you log in, there will be no history.

Notes

Maximum Length of Strings Enterable in the Search Bar

The maximum length of characters that can be entered in the search bar is 400 characters. You cannot enter more than 400 characters. When pasting text copied from the clipboard into the search bar, only up to 400 characters will be pasted; any characters beyond 401 will be truncated.

Therefore, please note the following restrictions:

When performing a fuzzy search by entering a keyword, the maximum length of the keyword is 400 characters.
When performing a logical search using a search formula, the maximum length of the entire search formula entered in the search bar, including the single quote (') indicating the start of logical operation, is 400 characters. When combining formulas with operators, the total length of the combined formula is limited to 400 characters.