Amazon Athena Query
Query data in Amazon S3 using Amazon Athena.
Properties
| Name | Type | |
|---|---|---|
| engine | String=athena:query | |
| credentials | Object | |
| output_bucket | String | |
| region | String | |
| query | String | |
| schema | Object | |
engine
Must be athena:query.
- Required
- Yes
credentials
The AWS credentials.
- Required
- Yes
Properties
| Name | Type | |
|---|---|---|
| access_key_id | String | |
| secret_access_key | String | |
credentials.access_key_id
Access key ID to authenticate with.
- Required
- Yes
credentials.secret_access_key
Secret access key to authenticate with.
- Required
- Yes
output_bucket
The S3 bucket to store the result in.
- Required
- Yes
region
The region to run Athena in.
- Required
- Yes
query
The SQL query to retrieve the data.
- Required
- Yes
schema
Define the schema of the data, entering the field name returned by the SQL query into `Source`.
- Required
- Yes