A use case of system SQL templates - 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

As there are many common, standardized SQL statements, Talend Studio allows you to benefit from various system SQL templates.

This section presents you with a use case that takes you through the steps of using MySQL system templates in a Job that:

  • opens a connection to a Mysql database.

  • collects data grouped by specific value(s) from a database table and writes aggregated data in a target database table.

  • deletes the source table where the aggregated data comes from.

  • reads the target database table and lists the Job execution result.

To connect to the database and aggregate the database table columns: