Skip to main content Skip to complementary content

Accessing a system SQL template

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.

Information noteNote: The system folders and their content are read only.

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


  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.


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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!