Advanced search - Cloud

Talend Cloud Pipeline Designer User Guide

EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Pipeline Designer
task
Administration and Monitoring > Monitoring executions
Administration and Monitoring > Monitoring logs
Data Governance > Filtering data
Data Quality and Preparation > Filtering data
Data Quality and Preparation > Managing datasets
Deployment > Deploying > Executing Pipelines
Design and Development > Designing Pipelines

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 Trust Score value of the dataset

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']