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