Creating a table analysis with a simple SQL business rule - Cloud

Talend Cloud API Services Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development
EnrichPlatform
Talend Management Console
Talend Studio

You can create analyses on either tables or views in a database using SQL business rules. The procedure for creating such analysis is the same for a table or a view.

Prerequisite(s):
  • At least one SQL business rule has been created in the Profiling perspective of the studio. For further information about creating SQL business rules, see Creating an SQL business rule

  • At least one database connection is set in the Profiling perspective of the studio. For further information, see Connecting to a database.

In this example, you want to add the SQL business rule created in Creating an SQL business rule to a top_custom table that contains an age column. This SQL business rule will match the customer ages to define those who are older than 18.