Scenario: Filtering SQlite data - 6.3

Talend Open Studio for Big Data Components Reference Guide

Talend Open Studio for Big Data
Data Governance
Data Quality and Preparation
Design and Development
Talend Studio

This scenario describes a rather simple job which uses a select statement based on a filter to extract rows from a source SQLite Database and feed an output SQLite table.

  • Drop from the Palette, a tSQLiteInput and a tSQLiteOutput component from the Palette to the design workspace.

  • Connect the input to the output using a row main link.

  • On the tSQLiteInput Basic settings, type in or browse to the SQLite Database input file.

  • The file contains hundreds of lines and includes an ip column which the select statement will based on

  • On the tSQLite Basic settings, edit the schema for it to match the table structure.

  • In the Query field, type in your select statement based on the ip column.

  • On the tSQLiteOutput component Basic settings panel, select the Database filepath.

  • Type in the Table to be fed with the selected data.

  • Select the Action on table and Action on Data. In this use case, the action on table is Drop and create and the action on data is Insert.

  • The schema should be synchronized with the input schema.

  • Save the job and run it.

The data queried is returned in the defined SQLite file.