Advanced search - Cloud

Talend Cloud Data Inventory User Guide
Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Data Inventory
Content
Administration and Monitoring > Managing connections
Data Governance
Data Quality and Preparation > Enriching data
Data Quality and Preparation > Identifying data
Data Quality and Preparation > Managing datasets
Last publication date
2024-02-28

You can use the advanced faceted search feature based on the Talend Query Language (TQL) to search more efficiently among your list of datasets.

Note: This feature becomes available for Talend Cloud Pipeline Designer users when Talend Cloud Data Inventory is enabled for the account.

From the dataset list, click Show faceted search > Advanced to enable the TQL search field. TQL allows you to accurately search for relevant datasets using a combination of facets and operators. After entering a facet and operator, simply type the value you are looking for between simple quotes.

List of facets
Facet Description
connection.type Type of the connection on which the dataset is based
connection.name Name of the connection on which the dataset is based
entity.attributes.Enum.<attribute id> List of all the enumeration type custom attributes defined beforehand
entity.attributes.Text.<attribute id> List of all the text type custom attributes defined beforehand
description Description of the dataset
name Name of the dataset
tags List of all the tags that have been applied on the datasets of an account.
globalQuality.valid Number of entries that are considered valid against the column types in the dataset sample
globalQuality.invalid Number of entries that are considered invalid against the column types in the dataset sample
globalQuality.empty Number of entries that are empty in the dataset sample
trustScore Talend Trust Score™ value of the dataset
apiStatus For a given dataset, an API can be Enabled, Disabled, Unconfigured, or Unsupported.
crawler List of all the datasets created using a specific crawler
List of operators
Operator Description Example
= Returns values that exactly match the specified value name = 'Season 2018/2019 results'
> Returns values that are greater than or equal to the specified value trustScore > 3.50
< Returns values that are less or equal to the specified value trustScore < 4.20'
!= Only returns values that do not match the specified value connection.type != 'Salesforce'
~ Returns values that match the specified regular expression description ~ '201[0-9]'
contains Returns values that contain the specified value description contains 'Talend'
containsIgnoreCase Returns values that contain the specified value regardless of the case connection.name containsIgnoreCase 'tAleND'
and Returns values that match all the specified values name contains '2019' and connection.type = 'MySQL'
or Returns values that match any of the specified values connection.type = 'Kafka' or connection.name contains 'Kafka'
in Returns any of the values from a specified list connection.type in ['Amazon S3', 'HDFS']