Setting up a Job to connect to Amazon Athena - 7.3

Data Integration Job Examples

author
Talend Documentation Team
EnrichVersion
7.3
EnrichProdName
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
task
Design and Development > Designing Jobs
EnrichPlatform
Talend Studio

Procedure

  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.
  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.

Results

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