Goal
This document explains how to integrate Amazon Athena into the Denodo Platform using its JDBC driver.
Content
Amazon Athena allows connectivity from Denodo using an official JDBC driver. You can find the documentation and the download links here: Using Athena with the JDBC Driver.
The JDBC data source can be defined like this using the native adapter for Amazon Athena:
Connection parameters details
Authentication: The authentication fields should be your AWS access key and AWS secret access key. Keep in mind that AWS security policies may need to be configured in order to allow access to AWS resources such as Athena. We recommend following the Access through JDBC and ODBC Connections section of the Athena documentation to get detailed information on how to configure the IAM permissions policy for this purpose.
Region: Ensure you replace the value “region” in the AwsRegion field with the region where your Amazon Athena installation is located. You can check this AWS document for more information about AWS regions including a list of the available ones.
Once you have configured the connection, you can proceed to create base views. Base views can be created easily with the usual mechanism from the Create base view section:
Base view
With the adapter, following the previous instructions, the connectivity to Amazon Athena should work properly:
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
Recommended resources
Questions
