Creating a table analysis with an SQL business rule in a shortcut procedure - Cloud - 7.3

Talend Studio User Guide

Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Talend Studio
Design and Development
Last publication date
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

You can use a simplified way to create a table analysis with a predefined business rule. All what you need to do is to start from the table name under the relevant DB Connection folder.

Before you begin

  • At least one SQL business rule is created in the Profiling perspective of Talend Studio.
  • At least one database connection is set in the Profiling perspective of Talend Studio.


  1. In the DQ Repository tree view, expand Metadata > DB Connections, and then browse to the table you want to analyze.
  2. Right-click the table name and select Table analysis from the list.
    The New Table Analysis wizard is displayed.
  3. Enter the metadata for the new analysis in the corresponding fields and click Next.
  4. Expand Rules > SQL to select the check boxes of the predefined SQL business rules you want to use on the corresponding tables.
  5. Click OK to proceed to the next step.
    The table name along with the selected business rule are listed in the Analyzed Tables view.
  6. Save the analysis and press F6 to execute it.

    An information pop-up opens to confirm that the operation is in progress and the analysis editor switches to the Analysis Results view.