Skip to main content

Validation of the data source template definition failed for Amazon Athena

Rich Talbot
  • Created
Date Posted:
Product: TIBCO Spotfire®

Problem:

Validation of the data source template definition failed for Amazon Athena


Solution:

Sometimes the validation for the data source template for Amazon Athena fails even after placing the required JDBC drivers in the tomcat\lib (10.2 and prior) or tomcat\custom-ext (10.3 and onwards) directory. The XML does not get parsed and shows the following status.
  

Validation of the data source template definition failed: Database driver com.amazonaws.athena.jdbc.AthenaDriver not found.


  The issue seems to be most likely with the JDBC Driver version. The XML fails to parse using any of the 2.0.X versions of the driver. To resolve this issue, we can try to instead use the 1.1.0 (AthenaJDBC41-1.1.0.jar) version of the driver which is compatible with JDBC 4.1 and JDK 7.0.

Download Link: https://docs.aws.amazon.com/athena/latest/ug/connect-with-previous-jdbc.html

Related articles

Comments

0 comments

Article is closed for comments.