Setting up a Job to connect to Amazon Athena - 8.0

Data Integration Job Examples

Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Talend Studio
Design and Development > Designing Jobs
Last publication date


  1. Create a Talend standard Job, drop two components to its design workspace: a tDBInput and a tLogRow, and label them based on your needs.
  2. Double-click the tDBInput component, select JDBC from the Database list, and click Apply.
  3. Connect the tDBInput and tLogRow components using a Row > Main connection.
    Screenshot of the Job in the Designer.
  4. In the Repository tree view, expand the JDBC connection you just created, select the table schema of interest, and drop it onto the tDBInput component.
    The connection information, table name, and schema are automatically set.
  5. Click Guess Query to generate the query clause, and edit it based on your needs.
  6. In the Basic settings view of the tLogRow component, click Sync columns to make sure it has the identical schema with the input components, and select theTable (each is key/value list) option for better readability of the console display.
  7. Press F6 to run your Job.


The Run console displays the data read from the Amazon Athena service.