Accessing a system SQL template - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
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
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

To access a system SQL template, expand the SQL Templates node in the Repository tree view.

Repository tree view.

Each folder contains a system sub-folder containing pre-defined SQL statements, as well as a UserDefined folder in which you can store SQL statements that you have created or customized.

Each system folder contains several types of SQL templates, each designed to accomplish a dedicated task.

Apart from the Generic folder, the SQL templates are grouped into different folders according to the type of database for which they are to be used. The templates in the Generic folder are standard, for use in any database. You can use these as a basis from which you can develop more specific SQL templates than those defined in Talend Studio.

Note: The system folders and their content are read only.

From the Repository tree view, proceed as follows to open a SQL template:

Procedure

  1. In the Repository tree view, expand SQL Templates and browse to the template you want to open.
  2. Double-click the class that you want to open, for example, Aggregate in the Generic folder.
    The Aggregate template view displays in the workspace.
    Aggregate template view.

Results

You can read the predefined Aggregate statements in the template view. The parameters, such as TABLE_NAME_TARGET, operation, are to be defined when you design related Jobs. Then the parameters can be easily set in the associated components, as mentioned in the previous section.

Every time you click or open a SQL template, its corresponding property view displays at the bottom of Talend Studio. Click the Aggregate template, for example, to view its properties as presented below:

Main configuration of the template.

For further information regarding the different types of SQL templates, see Types of system SQL templates.