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

Talend Real-time Big Data Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
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.