Setting up a JDBC connection to connect to Amazon Athena

Setting up a JDBC connection to connect to Amazon Athena - 8.0

Data Integration Job Examples

Version

8.0

Language

English

Product

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

Module

Talend Studio

Content

Design and Development > Designing Jobs

Last publication date

2024-02-06

Amazon Athena is currently available only in selected AWS regions. Verify the availability of the service from AWS global infrastructure region table.
You have the required additional library AthenaJDBC42-2.X.X.jar ready. If not, download the Athena JDBC driver here.
As the query results from Amazon Athena needs to be saved to Amazon S3, create an S3 output folder. For more information on Amazon Athena, Amazon S3, and JDBC, see:

In the Repository tree view of Talend Studio, expand the Metadata node, right-click Db Connections and select Create connection.

The Database connection wizard opens.
Provide the connection name and purpose and click Next.
From the DB Type list, select JDBC.

In the JDBC URL field, provide the JDBC URL details, including your AWS user ID and password.

jdbc:awsathena://AwsRegion=<AWS Region>;User=<AWS Access Key>;Password=<AWS Secret Key>;S3OutputLocation=<S3 folder>

Install the required additional library.
1. In the Drivers table, click the [+] button to add a line and click the [...] button to open the Module dialog box.
2. Select the Install a new module option, click the [...] button to browse to the downloaded jar.
3. Click OK to close the dialog box.
Back in the Database connection wizard, click the Select class name button and select the main class of the driver allowing to communicate with Amazon Athena.
Fill in your database user authentication data in the User Id and Password fields.
Click Test connection and then Finish to close the wizard.
In the Repository tree view, right-click the JDBC connection you just created and select Retrieve Schema to retrieve table schema of the connected Amazon Athena service.