Spring Boot 2 Project with Athena JDBC access using the JDBC Template. It uses the latest Athena JDBC Driver (for Java 8): AthenaJDBC42.
- Edit application.yml and set the AWS region
spring:
datasource:
url: jdbc:awsathena://AwsRegion=[REGION]
- Edit AthenaJdbcConfig.java and set the S3 Bucket where your query results should be saved
properties.put("s3_staging_dir", "S3 BUCKET WHERE THE RESULTS WILL BE SAVED"); // Line 19
The AWS credentials are supposed to be configured on your system.