Load data from Amazon Athena

This article explains how to connect to Amazon Athena and load data into Exasol.

Download JDBC driver

Download the latest Amazon Athena JDBC driver from the Connect to Athena with JDBC page on the Amazon Athena website.

If you want to use JDBC 2.x, download the JDBC 2.x driver with AWS SDK.

Add JDBC driver

To add the JDBC driver, create a configuration file called settings.cfg with the following settings:

Copy 
DRIVERNAME=Athena
PREFIX=jdbc:awsathena:
FETCHSIZE=100000
INSERTSIZE=-1
NOSECURITY=YES

Follow the procedure described in Add JDBC Driver to upload the settings.cfg configuration and JDBC driver files to Exasol.

Virtual schema

Exasol provides a virtual schema for connecting Amazon Athena as a data source to Exasol. For more information and downloads, see athena-virtual-schema in our GitHub repository.