Query
yaml
type: "io.kestra.plugin.aws.athena.query"Examples
yaml
id: aws_athena_query
namespace: company.team
tasks:
- id: query
type: io.kestra.plugin.aws.athena.Query
accessKeyId: "{{ secret('AWS_ACCESS_KEY_ID') }}"
secretKeyId: "{{ secret('AWS_SECRET_KEY_ID') }}"
region: "eu-central-1"
database: my_database
outputLocation: s3://some-s3-bucket
query: |
select * from cloudfront_logs limit 10
Properties
database *Requiredstring
outputLocation *Requiredstring
query *Requiredstring
accessKeyId string
catalog string
compatibilityMode booleanstring
endpointOverride string
fetchType string
Default
STORE Possible Values
STOREFETCHFETCH_ONENONEforcePathStyle booleanstring
region string
secretKeyId string
sessionToken string
skipHeader booleanstring
Default
truestsEndpointOverride string
stsRoleArn string
stsRoleExternalId string
stsRoleSessionDuration string
Default
PT15M Format
durationstsRoleSessionName string
Outputs
queryExecutionId string
row object
rows array
size integer
uri string
Format
uri