Creating user-defined SQL templates - Cloud - 8.0

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

As the transformation you need to accomplish in ELT may exceed the scope of what the given SQL templates can achieve, Talend Studio allows you to develop your own SQL templates according to some writing rules. These SQL templates are stored in the UserDefined folders grouped according to the database type in which they will be used.

For more information on the SQL template writing rules, see SQL statements.

To create a user-defined SQL template:


  1. In the Repository tree view, expand SQL Templates and then the category you want to create the SQL template in.
    SQL templates in the Repository tree view.
  2. Right-click UserDefined and select Create SQLTemplate to open the New SQL Template wizard.
    New SQL Template wizard.
  3. Enter the information required to create the template and click Finish to close the wizard.
    The name of the newly created template appears under UserDefined in the Repository tree view. Also, a SQL template editor opens on the design workspace, where you can enter the code for the newly created template.
    For further information about how to create a user-defined SQL template and how to use it in a Job, see the section about iterating on DB tables and deleting their content using a user-defined SQL template at MySQL.