| --- |
| name: AWS Athena |
| menu: Database Connectors |
| index: 0 |
| version: 1 |
| --- |
| |
| AWS Athena |
| ------------- |
| |
| The connection string for Amazon Athena is as follows: |
| |
| ``` |
| awsathena+jdbc://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}&... |
| ``` |
| Where you need to escape/encode at least the s3_staging_dir, i.e., |
| ``` |
| s3://... -> s3%3A//... |
| ``` |
| You can also use PyAthena library (no java required) as follows: |
| |
| ``` |
| awsathena+rest://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{ |
| ``` |