Load data from Amazon Athena

Learn 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

Create a configuration file called settings.cfg with the following settings:

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

The settings.cfg file must end with an empty line (line break followed by zero characters).

To learn how to upload the driver and the configuration file to an Exasol as-application deployment, see Add JDBC driver.

To learn how to upload the driver and the configuration file to Exasol SaaS, see Add JDBC driver (SaaS).

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.