Data discovery and organization
Qlik Catalog organizes data as hierarchies where objects are represented logically via entities [tables], attributes [columns/fields] and relationship properties [key/value] pairs.
Source Hierarchies are top level folder systems designed for drill in and drill out navigation of Data Sources.
Sources are collections of entities that share source and structural attributes that assist with loading and validation.
Entities are tables comprised of attributes [columns/fields] that answer specific relational queries.
New data is readily incorporated into source folders upon validation, profiling, and inheritance of attributes.
Parent object information
To view source information for an entity or entity metrics for a field, select the object (via tick or checkbox) and note the appearance of a carat next to breadcrumbs trail following Field or Entity at the top of the screen. Select the (carat) icon to display or collapse parent information for the selected entity or field.
Wildcard behavior for global and local search
The default search behavior for global and local search changed with the release of Qlik CatalogNovember 2021 SR1. Previously, the default behavior was "contains"-- if a name (or other field) contained the search term, a match resulted. For example, if a source was named "Payroll", a search term of "rol" would match it. In code, Catalog both prepended and appended the SQL multi-character wildcard "%". Now, with this change the default behavior is "starts with" -- if a name (or other field) starts with the search term, a match results. A search term of "pay" matches a source named "Payroll". In code, Catalog now only appends the SQL multi-character wildcard.
The user may manually prepend a wildcard, either the multi-character wildcard or the single-character wildcard "_". Searching for "%rol" mimics the prior behavior.
This change was made to enable users to perform "starts with"-only searches, which could not previously be performed. It is also more performant and makes the global and local searches consistent with the Catalog module search. Set the following core_env property to restor ethe previous behavior:
To search on names across a cluster in all grids and areas of the application, the global search field is available in the middle of the top navigation bar.
Preliminary search results display; select View all results in the upper right of the search results to open a screen with more information and drill-in options.
|View parent source|
|View parent entity|
Local search can be found directly above the grid and returns results found in that grid.