DataGrip Athena 연동

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