Amazon Athena JDBC

The Amazon Athena driver (v2.0) is included with Aqua Data Studio. 

Contents

• Driver Location
• Updating Driver Contents for use with Athena

Driver Location

You may locate the latest Athena JDBC drivers at the following location ...

Vendor: Amazon
Driver URL: https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html
Database Product: Amazon Athena

Updating Driver Contents for use Athena

To update the Aqua Data Studio JDBC drivers for Athena you need to overwrite the Aqua Data Studio athena.jar file. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...

WINDOWS

[ADS_INSTALL]\lib\drivers\athena.jar

C:\Program Files\Aqua Data Studio 21.1 - 64bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is B802-E063

 Directory of C:\Program Files\Aqua Data Studio 21.1 - 64bit\lib\drivers

01/04/2021  04:57 AM    <DIR>          .
01/04/2021  04:57 AM    <DIR>          ..
11/27/2020  02:27 PM           386,273 asm-all.jar
11/27/2020  02:27 PM            85,287 asm-commons.jar
11/27/2020  02:27 PM            94,658 asm.jar
11/27/2020  02:27 PM           323,422 asm4-all.jar
11/27/2020  02:27 PM         9,629,614 athena.jar
11/27/2020  02:27 PM            15,364 cassandra-clientutil-extras.jar
11/27/2020  02:27 PM            36,549 cassandra-clientutil.jar
11/27/2020  02:27 PM           228,286 cassandra-jackson-core-asl.jar
11/27/2020  02:27 PM           765,648 cassandra-jackson-mapper-asl.jar
11/27/2020  02:27 PM         1,073,177 cassandra-thrift.jar
11/27/2020  02:27 PM         6,550,443 db2jcc4.jar
11/27/2020  02:27 PM             1,015 db2jcc_license_cu.jar
11/27/2020  02:27 PM         3,232,770 derby.jar
11/27/2020  02:27 PM           588,394 derbyclient.jar
11/27/2020  02:27 PM           272,626 derbynet.jar
11/27/2020  02:27 PM           199,010 google-api-client.jar
11/27/2020  02:27 PM           107,293 google-api-services-bigquery-v2.jar
11/27/2020  02:27 PM             6,672 google-http-client-jackson2.jar
11/27/2020  02:27 PM           356,261 google-http-client.jar
11/27/2020  02:27 PM            10,776 google-oauth-client-java6.jar
11/27/2020  02:27 PM             5,799 google-oauth-client-jetty.jar
11/27/2020  02:27 PM            61,116 google-oauth-client.jar
11/27/2020  02:27 PM        18,438,062 hive-exec.jar
11/27/2020  02:27 PM            93,137 hive-jdbc.jar
11/27/2020  02:27 PM         5,273,347 hive-metastore.jar
11/27/2020  02:27 PM         1,860,639 hive-service.jar
11/27/2020  02:27 PM         1,094,202 ifxjdbc.jar
11/27/2020  02:27 PM           259,809 interclient.jar
11/27/2020  02:27 PM         2,115,735 jconnect16.jar
11/27/2020  02:27 PM           539,912 jetty-6.jar
11/27/2020  02:27 PM           177,131 jetty-util.jar
11/27/2020  02:27 PM         5,012,594 jt400.jar
11/27/2020  02:27 PM           549,861 jtds-src.jar
11/27/2020  02:27 PM           373,875 jtds.jar
11/27/2020  02:27 PM           619,873 mariadb.jar
11/27/2020  02:27 PM         3,071,453 mongo.jar
11/27/2020  02:27 PM         3,379,809 mysql-src.jar
11/27/2020  02:27 PM         1,006,904 mysql.jar
11/27/2020  02:27 PM         4,210,517 ojdbc8.jar
11/27/2020  02:27 PM         1,661,488 orai18n.jar
11/27/2020  02:27 PM           415,357 paraccel-jdbc.jar
11/27/2020  02:27 PM        38,354,188 phoenix.jar
11/27/2020  02:27 PM         1,002,883 postgresql.jar
11/27/2020  02:27 PM         2,515,568 redshift.jar
11/27/2020  02:27 PM        27,378,358 snowflake.jar
11/27/2020  02:27 PM         7,210,681 sqlite-jdbc.jar
11/27/2020  02:27 PM         1,300,917 sqljdbc42.jar
11/27/2020  02:27 PM           287,555 util400.jar
11/27/2020  02:27 PM        17,440,016 voltdb.jar
11/27/2020  02:27 PM           262,664 xdb6.jar
11/27/2020  02:27 PM         1,420,339 xmlparserv2.jar
11/27/2020  02:27 PM           779,974 zookeeper.jar
              52 File(s)    172,137,301 bytes
               2 Dir(s)  58,914,676,736 bytes free

C:\Program Files\Aqua Data Studio 21.1 - 64bit\lib\drivers>

LINUX

[ADS_INSTALL]/lib/drivers/athena.jar

Macos

Aqua Data Studio.app/Contents/Java/drivers/athena.jar

The Java class path for the drivers are already configured for ADS in the datastudio.ini for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching Aqua Data Studio from the command line.