DSS can connect to AWS Athena.
Tier 2 support: Connection to AWS Athena is covered by Tier 2 support
Athena is not a standalone SQL database. Instead, it is an interactive query layer on top on Amazon S3 data. The integration of Athena in DSS is designed primarily for querying S3 datasets built in DSS.
- Running interactive SQL notebooks on Athena based on previously-built S3 datasets
- Using Athena as charts engine for S3 datasets (partial support)
- Running SQL queries on Athena based on previously-built S3 datasets (execution and data read through Athena, write through DSS)
- Any form of write to Athena (writes should be made to a S3 dataset)
Installing the JDBC driver¶
- The JDBC Driver can be downloaded from https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html
- Copy the JAR file to the
- Restart DSS
Connecting to Athena¶
The recommended way to connect to Athena is to:
- Setup a S3 connection, including all potential advanced security options
- Create an Athena connection
- Select “From S3 connection” as the Credentials mode
- Enter the name of your S3 connection
The Athena connection will automatically use the same credentials as the S3 connection. Note that the credentials used for the S3 connection thus need Athena-related IAM permissions.
Using Athena on S3 data¶
Out of the box, you can