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

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

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

To know how to upload the JDBC driver and the configuration file to BucketFS, see Add JDBC Driver.

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.