Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Image Added

Contents

Table of Contents

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

No Format
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.