1. Athena JDBC Driver 다운로드
- https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html
2. Driver 추가
- [+] 아이콘 > Driver
1). Genaral 탭
- Name : ex) AWS Athena
- Driver files : [+] 아이콘 > Custom JARs... > 다운로드 받은 Athena JDBC Driver 선택
- Class : com.simba.athena.jdbc.Driver
- URL templates :
# AWS profile 사용시
jdbc:awsathena://AwsRegion=[{host::ap-northeast-2}][\?<;,{:identifier}={:param}>]
# Key, Secret 사용시
jdbc:awsathena://AwsRegion=[{host::ap-northeast-2}][\?<;,UID={user:param},PWD={password:param},{:identifier}={:param}>]
2). Advanced 탭
- S3OutputLocation : s3://쿼리-output-버킷명/
- Workgroup : primary
# AWS profile 사용시 필요
- AwsCredentialsProviderClass : com.simba.athena.amazonaws.auth.DefaultAWSCredentialsProviderChain
3. Data Source 추가
- [+] 아이콘> Data Source > AWS Athena
- Name : 원하는 이름
# AWS profile 사용시
- Host (AWS region) 확인 후 Test Connection
# Key, Secret 사용시
- Host : AWS region
- User : AWS Access Key Id
- Password : AWS Secret Access Key
> Test Connection