Native cloud deployment on Azure is currently not available for Exasol 8, but you can install Exasol as a Linux application on Azure VM instances. For more information, see Installation.

Native cloud deployment on GCP is currently not available for Exasol 8, but you can install Exasol as a Linux application on GCP VM instances.

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:

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.

Was this helpful?

YesNo

We're sorry to hear that.

Please let us know how we can improve.

Great!

If there's anything we can improve on, let us know.

Send Feedback

To help us understand your feedback, please include a link to this page.

stuff