Amazon Athena Query

Query data in Amazon S3 using Amazon Athena.

Properties

NameType
engineString=athena:query
credentialsObject
output_bucketString
regionString
queryString
schemaObject

engine

Must be athena:query.

Required
Yes

credentials

The AWS credentials.

Required
Yes

Properties

NameType
access_key_idString
secret_access_keyString

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