Amazon Athena connector

Last modified by Aurelie Bertrand on 2026/01/12 15:14

Prerequisites

You must have the Athena JDBC driver in the form of one or more JAR files and its documentation.

Digdash is only compatible with version 3.1.0 of the Athena JDBC driver. You can download it using this link: https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/3.1.0/athena-jdbc-3.1.0-lean-jar-and-separate-dependencies-jars.zip

Installation

Deploying the files

  1. (Optional, if the webapps have not yet been deployed). Start the DigDash Enterprise server and wait for the webapps to be fully deployed.
  2. Stop the server.
  3. Unzip the previously downloaded Athena archive.
  4. Some of the files contained in the archive are already delivered with Digdash in a different version that conflicts with the driver.
    Delete the following files from the runtime-dependencies folder:
    • httpclient-4.5.xx.jar
    • httpcore-4.4.xx.jar
    • slf4j-api-x.x.xx.jar
  5. Copy:
    ✔ the remaining JAR files to the runtime-dependencies folder
    ✔ the athena-jdb-3.1.x.jar file present at the root of the unzipped archive
    to the /home/digdash/webapps/default/ddenterpriseapi/WEB-INF/lib and /home/digdash/webapps/default/studio/WEB-INF/lib folders.
  6. The Athena JDBC driver must now be registered in DigDash Enterprise Server.

Registering the Athena JDBC driver

To register the driver :

  1. Edit the following file:
    <DD Install>/webapps/ddenterpriseapi/WEB-INF/classes/resources/config/sqldriverrepository.xml
  2. Add an XML entry to the sqldriverrepository.xml file, which looks like the following example:
        <SQLDriver id="ATHENA"
                       name="AWS Athena"
                       url="athena://"
                       manufacturer="Amazon Web Services"
                       class="com.amazon.athena.jdbc.AthenaDriver"
                       urlsample="jdbc:athena://"
                       availability="both">
               <properties></properties>
       </SQLDriver>

Important : Some characters are reserved in XML: '&', '"','<' or'>'. So if you use some of these characters, make sure you encode them to their corresponding XML entities.

XML correspondences :

  • & => &amp;
  • "=> &quot;
  • < => &lt;
  • > => &gt;

Example :

  • (FALSE) urlsample="jdbc:mydriver:dbtest?opt1=0&opt2="value""
  • (TRUE) urlsample="jdbc:mydriver:dbtest?opt1=0&amp;opt2=&quot;value&quot;"

Parameters :

  • id : an identifier used internally by DigDash Enterprise, choose a non-existent string, by convention in uppercase, without spaces
  • name : The name of the JDBC driver displayed in the administration console interface.
  • url : The URL prefix of the JDBC driver (without "jdbc:"). See the documentation supplied with the JDBC driver.
  • manufacturer : The name of the vendor/developer of the JDBC driver
  • class: path to the driver's main java class. See the documentation supplied with the JDBC driver.
    Optional: JDBC 4 standard JDBC drivers do not need the java class to be taken into account.
  • urlsample : Example of the URL displayed in the administration console interface.
  • availability : reserved. Leave at "both".

Important: Deployment is lost when you update the ddenterpriseapi.war file. Follow this driver deployment procedure each time you update DigDash Enterprise.

Advanced specific properties

Go to Add JDBC Driver Driver page for more information.

Configuring the database connection

To configure the database connection, proceed as described on the Database Connection Manager using the following items:

  1. From the Database Type drop-down list, select SQL.
  2. From the JDBC Driver drop-down list, select AWS Athena.
  3. Separate theURL as follows:
     jdbc:athena://WorkGroup=xxx;Region=xxx;AccessKeyId=xxx;SecretAccessKey=xxx;
  4. The user and password are already entered in the URL. There is therefore no need to enter them.